/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 vote205 views1 answer
Vbs
VBA
0 vote226 views1 answer
Excel vba first column in range
VBA
8 votes512 views1 answer
Excel vba make word from bytes
VBA
0 vote203 views1 answer
Excel vba StartUpPosition
VBA
0 vote196 views1 answer
Select case vba
VBA
0 vote201 views1 answer
Vba len variant
VBA
-1 vote194 views1 answer
For i in range vba
VBA
0 vote203 views1 answer
Remove last 8 characters from string vb
VBA
0 vote224 views1 answer
Vba table header name
VBA
25 votes523 views3 answers
String to date vb
VBA