How do i seperate colums when special pasting information

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

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
 
Hi Brian

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

JY
 
You must log in or register to reply here.

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

Getting Data Validation to execute when using Paste Special... Val 3
paste special macro stops working when run a 2nd time 1
VBA code to replace Past Special 4
Paste by rows and blank cell problems 1
How do you trap the paste event in a worksheet? 2
same sheet copy/paste special 2
Text To Columns then insert rows 9
Paste Special MS Excel Worksheet range selection into Outlook Task 1

Back
Top