Separatting Data in Columns

G

G. Allen

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?
 
N

Niek Otten

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?
 
B

Bren.ie

Highlight column
Ckick Data > Text to columns,
Use Delimeed setting click next
Select comma click next
Finis
 
Top