Separating Commas in an Excel field

  • Thread starter Thread starter klprice116
  • Start date Start date
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!
 
Hi
Simply do Data, Text to Columns... and follow the wizard instructions
(your separator will be a comma)
regards
Paul
 
Back
Top