Home

Data to Column Issues

%3CLINGO-SUB%20id%3D%22lingo-sub-535542%22%20slang%3D%22en-US%22%3EData%20to%20Column%20Issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-535542%22%20slang%3D%22en-US%22%3E%3CP%3EI%20had%20a%20list%20of%20contact%20information%20created%20from%20Pakistan.%20The%20file%20I%20received%20does%20not%20allow%20me%20use%20the%20data%20to%20column%20tool%20to%20quickly%20separate%20the%20first%20and%20last%20names.%20When%20I%20use%20the%20tool%2C%20it%20would%20only%20separate%20the%20second%20and%20third%20name%20if%20there%20were%20any.%20Office%20365%20tech%20support%20was%20not%20able%20to%20assist%20me.%20they%20sent%20me%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-535542%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-535638%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20to%20Column%20Issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-535638%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F335326%22%20target%3D%22_blank%22%3E%40vegasjohnny%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20have%20both%20spaces%20and%20non-breaking%20spaces%20CHAR(160)%20as%20separator%20for%20the%20names.%20On%20second%20step%20of%20the%20wizard%20select%20space%20and%20Other.%20Into%20Other%20box%20pressing%20Alt%20type%200160%20on%20Numepad%20(or%20copy%20the%20character%20from%20your%20text%20and%20paste).%3C%2FP%3E%3C%2FLINGO-BODY%3E
vegasjohnny
Occasional Visitor

I had a list of contact information created from Pakistan. The file I received does not allow me use the data to column tool to quickly separate the first and last names. When I use the tool, it would only separate the second and third name if there were any. Office 365 tech support was not able to assist me. they sent me here.

1 Reply
Highlighted

@vegasjohnny ,

 

You have both spaces and non-breaking spaces CHAR(160) as separator for the names. On second step of the wizard select space and Other. Into Other box pressing Alt type 0160 on Numepad (or copy the character from your text and paste).

Related Conversations