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