/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 vote248 views2 answers
Vba string length
VBA
0 vote240 views1 answer
How to extract a file from an ISO:
VBA
0 vote232 views1 answer
Vba loop through table
VBA
0 vote227 views1 answer
Send webhook vbscript
VBA
5 votes255 views1 answer
Excel vba get low byte from INTEGER
VBA
22 votes557 views1 answer
Xl vba check for folder
VBA
1 vote244 views1 answer
How to remove zeros in excel
VBA
0 vote241 views1 answer
Compare dates vb
VBA
0 vote254 views1 answer
Vba character ascii code
VBA
0 vote263 views1 answer
Amd64 vs arm64 linux
VBA