/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

1 vote148 views1 answer
Vba loop through files in folder
VBA
15 votes258 views2 answers
Xl vba dynamic string array
VBA
0 vote141 views1 answer
VBA is form loaded
VBA
0 vote175 views1 answer
Vba userform textbox wrap text
VBA
0 vote145 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote144 views1 answer
Vba vbcrlf chr
VBA
5 votes155 views2 answers
Excel vba write to the windows registry
VBA
0 vote148 views1 answer
Date as number vb
VBA
0 vote173 views1 answer
Vbnet add axis labels to chart
VBA
0 vote151 views1 answer
Vbscript check if string contains
VBA