Parsing a column

%3CLINGO-SUB%20id%3D%22lingo-sub-1721993%22%20slang%3D%22en-US%22%3EParsing%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1721993%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20parse%20a%20column%20of%20names%20using%20the%20Data%2C%20Text%20to%20Columns%20function.%26nbsp%3B%20I%20follow%20the%20directions%20to%20the%20letter%20and%20all%20it%20does%20is%20copy%20the%20original%20column%20to%20the%20next%20column%20without%20separating%20the%20space%20designator.%26nbsp%3B%20Any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1721993%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1722019%22%20slang%3D%22en-US%22%3ERe%3A%20Parsing%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1722019%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F812313%22%20target%3D%22_blank%22%3E%40hepeabody%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThere%20are%20non-breaking%20spaces%20between%20the%20parts%20of%20the%20names.%3C%2FP%3E%0A%3CP%3EIn%20Step%202%20of%20the%20Convert%20Text%20to%20Columns%20wizard%2C%20select%20Other.%3C%2FP%3E%0A%3CP%3EClick%20in%20the%20box%20next%20to%20it.%3C%2FP%3E%0A%3CP%3EHold%20down%20Alt%20and%20press%200160%20on%20the%20numeric%20keypad%2C%20then%20release%20Alt.%3C%2FP%3E%0A%3CP%3E(Alternatively%2C%20select%20and%20copy%20one%20of%20the%20spaces%20before%20starting%20Text%20to%20Columns%2C%20and%20paste%20the%20space%20into%20the%20box).%3C%2FP%3E%0A%3CP%3EClick%20Finish.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am trying to parse a column of names using the Data, Text to Columns function.  I follow the directions to the letter and all it does is copy the original column to the next column without separating the space designator.  Any ideas?

2 Replies

@hepeabody 

There are non-breaking spaces between the parts of the names.

In Step 2 of the Convert Text to Columns wizard, select Other.

Click in the box next to it.

Hold down Alt and press 0160 on the numeric keypad, then release Alt.

(Alternatively, select and copy one of the spaces before starting Text to Columns, and paste the space into the box).

Click Finish.

@Hans Vogelaar 

 

Thank you!  I have been fighting this all morning.