Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jmboggiano
 
Posts: n/a
Default 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!
  #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!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you prevent users from pasting over validated cells? LCK Excel Discussion (Misc queries) 3 March 2nd 05 09:28 PM
Lookup with two variable data list cells Monkey Excel Worksheet Functions 2 February 10th 05 11:29 PM
Eliminate creating list that returns blank cells Marc Todd Excel Worksheet Functions 1 January 26th 05 09:58 PM
automatic color change in cells using a drop down list kennethwt Excel Worksheet Functions 1 January 21st 05 06:37 PM
Validation - List - Separate Worksheet J. Osborne Excel Worksheet Functions 1 October 28th 04 04:23 PM


All times are GMT +1. The time now is 01:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"