/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 vote292 views1 answer
Excel vba ternary
VBA
22 votes461 views1 answer
Xl vba check for folder
VBA
4 votes288 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
1 vote297 views2 answers
Vba string length
VBA
0 vote312 views1 answer
Vba integer to double
VBA
0 vote273 views1 answer
Vba get text file content
VBA
5 votes291 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
1 vote302 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
1 vote282 views1 answer
Add a index column power bi
VBA
1 vote284 views1 answer
Vba refresh pivot table
VBA