/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 vote119 views1 answer
Vb net check if file exists
VBA
0 vote135 views1 answer
VBA
VBA
0 vote131 views1 answer
Vba dictionary length
VBA
0 vote123 views1 answer
Vb window.minimize
VBA
0 vote131 views1 answer
Vba change active sheet
VBA
0 vote120 views1 answer
Vba add month to date
VBA
3 votes144 views1 answer
Extract word in a text in excel
VBA
2 votes116 views1 answer
Vba uppercase first letter of each word
VBA
0 vote131 views1 answer
Excel vba unmerge sheet
VBA
0 vote121 views1 answer
Vba get text file content
VBA