/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

3 votes184 views1 answer
Extract the nth word from a text string
VBA
22 votes346 views1 answer
Excel vba check if directory exists
VBA
1 vote165 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote176 views1 answer
Excel vba delete folder
VBA
0 vote162 views1 answer
Remove frist letter from string vbnet
VBA
4 votes176 views1 answer
Excel vba how to reset usedrange
VBA
0 vote182 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote186 views1 answer
Vba exit while
VBA
0 vote193 views1 answer
Vba code to select image in sheet
VBA
0 vote171 views1 answer
Test if form is open vb
VBA