/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 vote127 views1 answer
Excel vba set cell value to empty
VBA
0 vote130 views1 answer
Regex numeric digits
VBA
0 vote130 views1 answer
Excel vba round to whole number
VBA
5 votes126 views1 answer
Xlvba double quotes in string literal
VBA
5 votes120 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
4 votes119 views1 answer
Excel vba check cell not empty
VBA
0 vote145 views1 answer
How to enter Vbox manage commands
VBA
0 vote124 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote120 views1 answer
Vba get text file content
VBA
0 vote118 views1 answer
Prive sub enter clicked vb
VBA