/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 vote314 views1 answer
Vbs expand env var
VBA
0 vote307 views1 answer
Excel vba range contains
VBA
0 vote343 views1 answer
Vba boolean to string
VBA
0 vote342 views1 answer
VBA
VBA
0 vote276 views1 answer
Excel vba concatenate range
VBA
1 vote312 views1 answer
Excel format cell as kilowatts
VBA
0 vote308 views1 answer
Vba type variable
VBA
4 votes305 views1 answer
Excel vba check cell not empty
VBA
0 vote347 views1 answer
Excel web scraping
VBA
0 vote273 views1 answer
How to self delete a vbscript file
VBA