/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 vote298 views1 answer
Vba compare strings
VBA
0 vote280 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote301 views4 answers
How to continue formula in below line in vba code
VBA
0 vote330 views1 answer
Vbs run with cscript
VBA
0 vote326 views1 answer
Excel vba protect scenarios
VBA
0 vote285 views1 answer
Vba type variable
VBA
0 vote281 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote305 views1 answer
Excel vba combine ranges
VBA
0 vote310 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote306 views1 answer
Vba run command
VBA