/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 vote192 views1 answer
Excel vba named range exists
VBA
0 vote181 views1 answer
Vba remove last vbcrlf
VBA
0 vote178 views1 answer
Move bindingnavigator vb
VBA
0 vote180 views1 answer
Vba find sub dictionary
VBA
0 vote265 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote184 views2 answers
Open url from vba
VBA
0 vote164 views1 answer
Vba copy paste value only
VBA
0 vote216 views1 answer
Wpf dark title bar
VBA
5 votes185 views1 answer
Excel vba left word from Long Integer
VBA
5 votes187 views1 answer
Excel vba low word from Long Integer
VBA