Pasting CSV list into separate cells...

J

jmboggiano

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!
 
J

JulieD

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
 
Top