Pasting CSV list into separate cells...

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

Guest

If I paste it into excel the entire text string goes into one cell. I would
like to be able to paste and then have excel recognize it is a CSV list and
put each value in its own cell. I've tried "paste special" but could not see
how to do it.

Can this be done?

Thanks!
 
Hi

once you've pasted it click on the cell and use data / text to columns
option
on the first screen choose delimited and then on the next choose comma.

Cheers
JulieD
 
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

Excel CSV Files; Creating Of 3
Problem with CSV file 6
CSV->Excel Data Problem 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
How do you paste a list of bulleted text from a word doc. into exc 2
copy formulas from one worksheet to an entirely different workshee 2
Excel And Notepad 3
how do I change a csv extension file to an xls file and use it? 1

Back
Top