/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 vote247 views1 answer
Excel vba open browser
VBA
0 vote292 views1 answer
Vba registry settings
VBA
0 vote261 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote269 views1 answer
Remove frist letter from string vbnet
VBA
1 vote263 views1 answer
Excel vba close form escape key
VBA
0 vote281 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote271 views1 answer
Internet explorer reference vba
VBA
2 votes262 views1 answer
Vba array contains
VBA
0 vote287 views1 answer
Vba array dimensions
VBA
6 votes307 views1 answer
Excel vba get the path of current workbook
VBA