/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 vote232 views1 answer
Return na vba
VBA
5 votes267 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote237 views1 answer
Set column width of datagridview vb.net
VBA
3 votes225 views1 answer
Vba request json
VBA
3 votes246 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote244 views1 answer
Vba file chooser
VBA
0 vote228 views1 answer
Check range is in another range vba
VBA
2 votes238 views1 answer
Excel vba check if string entirely numeric
VBA
1 vote239 views1 answer
Vba reverse string
VBA
-1 vote216 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA