Question : vba remove leading blank space in string
Answered by : thoughtless-tapir-5iqd7uarme6m
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 FunctionSource : https://stackoverflow.com/a/56720228/11998874 | Last Update : Tue, 15 Dec 20