SOLVED

Remove leading spaces w/o removing all spaces

%3CLINGO-SUB%20id%3D%22lingo-sub-3111133%22%20slang%3D%22en-US%22%3ERemove%20leading%20spaces%20w%2Fo%20removing%20all%20spaces%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3111133%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20remove%20the%20leading%20spaces%20%2F%20phantom%20spaces%20in%20this%20data%20without%20removing%20all%20spaces%3F%20I%20already%20tried%20using%3A%3C%2FP%3E%3COL%3E%3CLI%3EFind%20%26amp%3B%20Replace%3C%2FLI%3E%3CLI%3EText%20to%20Columns%20%26gt%3B%20Fixed%20Width%3C%2FLI%3E%3C%2FOL%3E%3CP%3EThe%20second%20option%20works%20for%20this%20small%20data%20set%2C%20but%20it%20would%20not%20work%20well%20with%20a%20large%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20ideas%20are%20welcome!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Network.jpg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F345022i2182C43D74E4A0DD%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Network.jpg%22%20alt%3D%22Network.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3111133%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3111399%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20leading%20spaces%20w%2Fo%20removing%20all%20spaces%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3111399%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383741%22%20target%3D%22_blank%22%3E%40ashleyb_adams%3C%2FA%3E%26nbsp%3BYou%20may%20use%3C%2FP%3E%3CP%3E%3DTRIM(%20A1%20)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

How do I remove the leading spaces / phantom spaces in this data without removing all spaces? I already tried using:

  1. Find & Replace
  2. Text to Columns > Fixed Width

The second option works for this small data set, but it would not work well with a large one.

 

All ideas are welcome!

Network.jpg

1 Reply
best response confirmed by ashleyb_adams (Occasional Contributor)
Solution

@ashleyb_adams You may use

=TRIM( A1 )