/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 vote397 views1 answer
Vba count all row
VBA
27 votes509 views2 answers
Vba check if file exists
VBA
0 vote355 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote324 views1 answer
Add items to combobox vb.net
VBA
0 vote349 views1 answer
Telephon call in vba
VBA
0 vote398 views1 answer
Vba boolean to string
VBA
0 vote369 views1 answer
Weekday vba
VBA
0 vote358 views1 answer
Find the name of the last excel sheet vb
VBA
3 votes390 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote360 views1 answer
Excel vba cell on change
VBA