/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 vote328 views1 answer
How to format a textbox as date vb net
VBA
0 vote295 views1 answer
Vba dictionary length
VBA
2 votes256 views1 answer
Excel vba pause
VBA
5 votes319 views1 answer
Xl vba double quotes in string literal
VBA
5 votes334 views1 answer
Excel vba tool to help with refactoring code
VBA
3 votes317 views1 answer
Vba http request json
VBA
1 vote298 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote297 views1 answer
Vba exit while
VBA
0 vote315 views1 answer
Weekday vba
VBA
0 vote319 views1 answer
Excel vba first working day month
VBA