/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 vote336 views1 answer
Openfiledialog specific folder
VBA
1 vote345 views2 answers
Get all column names from excel vba
VBA
5 votes343 views1 answer
Excel vba low byte from INTEGER
VBA
0 vote344 views1 answer
Loop through all text boxes in a form vb
VBA
2 votes321 views1 answer
Excel vba check if key is in collection
VBA
0 vote354 views1 answer
Vba integer to double
VBA
0 vote359 views1 answer
Create links in msgbox in vb
VBA
4 votes331 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
1 vote332 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
0 vote303 views1 answer
How to make a if statement with vbs
VBA