/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 vote251 views1 answer
Excel vba move down to next visible cell
VBA
11 votes506 views1 answer
Excel vba How to URL encode a string
VBA
1 vote235 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote225 views1 answer
Vbscript for loop
VBA
0 vote230 views1 answer
Refresh token em vb net
VBA
0 vote236 views1 answer
Excel vba unmerge sheet
VBA
0 vote251 views1 answer
Priavte sub with multiple handels find sneder
VBA
1 vote229 views1 answer
Excel vba unload userform
VBA
0 vote238 views1 answer
Arq linux
VBA
7 votes244 views1 answer
Excerl vba array to range
VBA