/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 votes171 views1 answer
Excel vba change format of cell
VBA
4 votes159 views2 answers
Vba array length
VBA
0 vote158 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote176 views1 answer
Vba clear collection
VBA
0 vote186 views1 answer
How to enter Vbox manage commands
VBA
4 votes170 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
3 votes182 views1 answer
Extract word in a text in excel
VBA
1 vote114 views1 answer
How to open cmd with vbd
VBA
0 vote154 views1 answer
How to use VBA to add new record in MS Access?
VBA
3 votes171 views1 answer
Vba continue for each loop
VBA