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...
- Jul 01, 2020
Matt_MobiusNZ Indeed frustrating when things don't function as you expect them to. But, allow me to add one more comment. In your screenshot you show the Insert ribbon while inside the header. Don't you have a separate "Header & Footer" ribbon when you click inside the header? See picture below. I have all the header and footer options here, including inserting pictures and reformatting them once inserted.
This is my Excel version, running W10 on a virtual machine on a MB Pro.
Riny_van_Eekelen
Feb 03, 2022Platinum Contributor
Ashley You may use
=TRIM( A1 )