How do i seperate colums when special pasting information
 

I am pasting data into Excel from an external source by using special paste.
This is working with no problems apart from all the data is going into one
cell.
How can i split it up into different coloumns.

Thanks

How do i seperate colums when special pasting information
 

Hi Brian

Use the Data menu, select Text to table
Select the delimeter you want
HTH

JY

"Brian" wrote in message
...
I am pasting data into Excel from an external source by using special
paste.
This is working with no problems apart from all the data is going into one
cell.
How can i split it up into different coloumns.

Thanks