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

Excel does not accept text format! 0
Adding Cost Field to Appointment 0
Formating bolded text exclusively. 0
How to export a range to CSV 3
Page numbering with Merged Document and IF statements 1
XLL ('C' extension) question 2
Add Values in a comma separated cell to combobox 2
Import a comma delimited file & match records 3

Top