/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 vote174 views1 answer
Replace spaces with underscores vbnet
VBA
1 vote148 views1 answer
How to open cmd with vbd
VBA
1 vote189 views1 answer
How to put a gridpain in a vbox
VBA
0 vote176 views1 answer
Vbnet check if string is only symbols
VBA
3 votes198 views1 answer
Vba not equal
VBA
3 votes196 views1 answer
Excel vba change format of cell
VBA
0 vote185 views2 answers
Open url from vba
VBA
0 vote182 views1 answer
Excel vba first working day month
VBA
0 vote186 views1 answer
Type excel.application is not defined vb
VBA
1 vote182 views1 answer
Excel format cell as kilowatts
VBA