/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 vote322 views1 answer
Vba sheet visible
VBA
0 vote365 views1 answer
Excel vba copy range with filter
VBA
0 vote346 views1 answer
Vba round to 2 decimals
VBA
5 votes320 views1 answer
Vba array worksheet.index
VBA
0 vote354 views4 answers
Jwt token vb.net validation
VBA
2 votes327 views1 answer
Excel vba date to string conversion
VBA
5 votes369 views1 answer
Vba low word from Long Integer
VBA
3 votes348 views1 answer
Vba not equal
VBA
4 votes326 views1 answer
Excel vba check cell not empty
VBA
32 votes527 views2 answers
Excel vba column letter
VBA