/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 vote233 views1 answer
Discern between file and folder given path vb.net
VBA
3 votes266 views1 answer
Extract word in a text in excel
VBA
0 vote235 views1 answer
Vba text to general
VBA
0 vote251 views1 answer
Excel vba round to whole number
VBA
0 vote250 views1 answer
Excel vba join variant array
VBA
1 vote238 views2 answers
Vba string to date
VBA
0 vote252 views1 answer
VBA Sleep Snippet
VBA
0 vote298 views2 answers
Excel vba store array and write to sheet
VBA
0 vote246 views1 answer
Regex numeric digits
VBA
0 vote256 views1 answer
Vba sort the data Z to A
VBA