/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 vote148 views1 answer
Change form background image vb
VBA
0 vote146 views1 answer
Loop through lines in text file vb net
VBA
0 vote151 views1 answer
Vba len variant
VBA
0 vote177 views1 answer
Iterate all file in a folder vba
VBA
4 votes165 views2 answers
Vba create folder if not exist
VBA
0 vote161 views1 answer
Excel vba unlock sheet without password
VBA
0 vote163 views1 answer
Vba is integer
VBA
0 vote155 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote150 views1 answer
Find days in month vba
VBA
3 votes147 views1 answer
Vba request json
VBA