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
collaboration and coauthoring issues in teams
Ethan Stern in Microsoft Teams on
6 Replies
Pulling data from one tab to another
krysphares in Excel on
6 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies