View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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!