Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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! |
#2
![]() |
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you prevent users from pasting over validated cells? | Excel Discussion (Misc queries) | |||
Lookup with two variable data list cells | Excel Worksheet Functions | |||
Eliminate creating list that returns blank cells | Excel Worksheet Functions | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Validation - List - Separate Worksheet | Excel Worksheet Functions |