/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

3 votes166 views1 answer
Extract the nth word from a text string
VBA
0 vote163 views1 answer
Excel vba disable keyboard input
VBA
0 vote155 views1 answer
Excel vba disable screen update
VBA
25 votes310 views2 answers
Excel vba folder exist
VBA
4 votes174 views2 answers
Excel vba last column with data
VBA
5 votes190 views1 answer
Excel vba first byte from INTEGER
VBA
3 votes176 views1 answer
Vba post request json
VBA
-1 vote177 views2 answers
Excel vba delete empty rows
VBA
3 votes186 views1 answer
Extract word in a text in excel
VBA
0 vote160 views1 answer
Hello world vb.net
VBA