/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 vote167 views1 answer
Excel vba existence of a file
VBA
0 vote164 views1 answer
Vbnet check if string is only symbols
VBA
0 vote187 views1 answer
Excel web scraping
VBA
0 vote158 views1 answer
Afficher un message d'erreur vba
VBA
0 vote181 views1 answer
Find database connection string vb
VBA
1 vote178 views1 answer
Vbs run
VBA
1 vote170 views1 answer
Add a index column power bi
VBA
0 vote178 views2 answers
Excel vba protect cells with formula
VBA
5 votes183 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote154 views1 answer
Vba word pdf table to excel
VBA