/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 vote342 views1 answer
Convert unix to date vba
VBA
0 vote355 views1 answer
Vba sort multiple columns
VBA
0 vote345 views1 answer
Vbs write file
VBA
0 vote360 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote363 views1 answer
Excel vba prevent saving workbook
VBA
1 vote396 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote356 views1 answer
Excel vba calculate
VBA
0 vote372 views1 answer
Vba random number
VBA
0 vote380 views1 answer
Excel vba named range exists
VBA
0 vote349 views1 answer
Search in richtextbox vb.net
VBA