Nitesh Khot
Member
Hi..
Attached file where string contains leading space but unable to remove using vba trim function.
How to remove leading space from string using VBA as trim function in vba working but not removing leading space.
Attached file where string contains leading space but unable to remove using vba trim function.
How to remove leading space from string using VBA as trim function in vba working but not removing leading space.
Code:
For Each x In Selection
x.Value = Application.WorksheetFunction.Trim(x.Value)
Next x