/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 vote177 views1 answer
Excel vba join variant array
VBA
0 vote188 views1 answer
Make your computer talk vbscript
VBA
0 vote186 views1 answer
Excel vba cell on change
VBA
1 vote190 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
4 votes193 views2 answers
Excel vba last column with data
VBA
0 vote188 views1 answer
Vba type
VBA
1 vote176 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote225 views1 answer
Vbnet add axis labels to chart
VBA
0 vote186 views1 answer
Make all controls in an area not visable vb
VBA
-1 vote200 views1 answer
How to correct a number to 2 decimal places in vba
VBA