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

@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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies