Separating Commas in an Excel field

K

klprice116

I am trying to separate information that was exported into Excel and
separated by commas but when exported the information merged together into 2
colums and not the 4 as it should... I now have to go back and copy paste and
separate information manually. Is there a way (formula) that I can have
Excel separate information found behind a comma? Thanks for your assistance!
 
P

paul.robinson

Hi
Simply do Data, Text to Columns... and follow the wizard instructions
(your separator will be a comma)
regards
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why does Excel think this is a number? 6
Excel VBA - Force 4 commas into a text field on userform 7
Separating data in the same cell 1
How to delete commas and spaces when not needed ... S&R way, or macro way? 11
Save .csv file. Decimals separated by commas 2
Separating names & addresses in a spreadsheet 1
De-concatenate but maintain relationship/record structure 3
Importing a Text File Into 1 Column 14

Top