Pasting CSV list into separate cells...
 

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


"jmboggiano" wrote in message
...
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!