Forum Discussion
Ashley
Feb 03, 2022Iron Contributor
Remove leading spaces w/o removing all spaces
How do I remove the leading spaces / phantom spaces in this data without removing all spaces? I already tried using: Find & Replace Text to Columns > Fixed Width The second option works for this...
- Feb 03, 2022
Ashley You may use
=TRIM( A1 )
Riny_van_Eekelen
Feb 03, 2022Platinum Contributor
Ashley You may use
=TRIM( A1 )