Separatting Data in Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thank you to all in advance for your clever assistance. Problem: I've data separated by a comma in a column which needs to be in two columns. Is there a quick to achieve this?
 
Data>Text to columns>Separated>Commas

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

G. Allen said:
Thank you to all in advance for your clever assistance. Problem: I've
Click to expand...
data separated by a comma in a column which needs to be in two columns. Is
there a quick to achieve this?
 
Highlight column
Ckick Data > Text to columns,
Use Delimeed setting click next
Select comma click next
Finis
 

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

Text to columns 4
Excel Help to copy information from one row at a time to another sheet 1
Split column 3
Excel Comparing two columns 1
Sorting data in various columns 2
data splitting 1
Add comma after last " in a cell 14
how do I sort a column mixed with odd and even numbers .. ? 1

Back
Top