/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 vote385 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote371 views1 answer
Vba code for cutoff time
VBA
1 vote385 views1 answer
How to remove zeros in excel
VBA
0 vote390 views1 answer
Add text to Shape VBA
VBA
1 vote359 views1 answer
How to open cmd with vbd
VBA
3 votes378 views1 answer
Vba not equal
VBA
0 vote347 views1 answer
Excel vba populate array with cell values
VBA
0 vote382 views1 answer
Vba integer to double
VBA
0 vote354 views1 answer
Vba text to general
VBA
0 vote379 views1 answer
Vbs exec hidden
VBA