RE: Opposite of concatenate - splitting of column

Hello Sue,

Hope you enjoyed your Microsoft Excel advanced course with Best STL.

Thank you for your question regarding splitting the contents of a column into 2 columns.

There is a tool called Text to Columns that does this in a few simple steps. First add a new column to the right of your data then select the column of data you wish to split into 2 columns (CTRL+Shift+down-arrow). Next, go to the data ribbon and from the Data Tools group click the Text to Columns button.

Select Fixed Width and click Next. In the data preview window click with your mouse between the last 2 characters. This places a line between these 2 characters then click Next. If you wish to format the data this is done at this step (not really necessary) then click Finish. Job done! You should now have 2 columns exactly as you wanted.

Try it out!

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer