/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 vote158 views1 answer
How to sort datagridview in vb.net
VBA
0 vote238 views1 answer
Group controls programmatically vb
VBA
-1 vote208 views2 answers
How close excel through visual basic
VBA
1 vote202 views1 answer
Vba ubound array 2-dimensional
VBA
3 votes232 views1 answer
Excel insert blank row for value change in column
VBA
0 vote217 views1 answer
Discern between file and folder given path vb.net
VBA
2 votes207 views1 answer
Excel vba check if key is in collection
VBA
0 vote200 views1 answer
Vba word pdf table to excel
VBA
0 vote216 views1 answer
Vba first line of string
VBA
0 vote203 views1 answer
Excel vba join variant array
VBA