/VBA/Vba code to remove leading and trailing spaces

Vba code to remove leading and trailing spaces

Vba remove leading blank space in string

Option Explicit
Function trimWhiteSpace(s As String) As String
	Dim RE As Object: Set RE = CreateObject("vbscript.regexp")
	With RE
		.Global = True
		.MultiLine = True
		.Pattern = "^\s*(\S.*\S)\s*"
		trimWhiteSpace = .Replace(s, "$1")
	End With
End Function

Source: stackoverflow.com

Similar codes

0 vote180 views1 answer
How to sort datagridview in vb.net
VBA
0 vote210 views1 answer
Vba option button selected
VBA
0 vote219 views1 answer
Reset border color textbox vba
VBA
5 votes222 views1 answer
Excel formula how to create strings containing double quotes
VBA
0 vote214 views1 answer
Vbnet find highest value in chart
VBA
1 vote230 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote224 views1 answer
Vba get workbook name
VBA
0 vote222 views1 answer
VB Error Code BC30201
VBA
0 vote218 views2 answers
Delete all controls from list of control vb.net
VBA
2 votes247 views2 answers
Excel vba if sunday or staurday
VBA