/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 vote195 views1 answer
Vbnet find highest value in chart
VBA
0 vote203 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote284 views1 answer
Vba change active sheet
VBA
0 vote207 views1 answer
Vba extract filename from path
VBA
3 votes194 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
1 vote221 views1 answer
Vba format string as cash
VBA
0 vote178 views1 answer
Excel vba open browser
VBA
0 vote190 views1 answer
Compare dates vb
VBA
0 vote247 views1 answer
How to call gcd in vba
VBA
0 vote196 views1 answer
Excel vba disable screen update
VBA