No csv format in Paste Special

[dborski]

For some reason I don't have the option to choose a csv format whe
using Paste Special to copy data into excel. I'm using Excel 2000 ve
9.0.3821 Sr-1.

I know that csv it is available because my coworkers have it.

Does anyone know how to add the csv option

 

[Jim Rech]

There is no CSV option in the Paste Special dialog for Excel. However,
sometimes a paste will wind up parsing text for the reason explained in this
article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;127132

--
Jim
message |
| For some reason I don't have the option to choose a csv format when
| using Paste Special to copy data into excel. I'm using Excel 2000 ver
| 9.0.3821 Sr-1.
|
| I know that csv it is available because my coworkers have it.
|
| Does anyone know how to add the csv option?
|
|
| --
| dborski
| ------------------------------------------------------------------------
| dborski's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=25918
| View this thread: http://www.excelforum.com/showthread.php?threadid=392913
|

 

[dborski]

Thank you for your reply. You are correct in that there is no cs
option on the initial "paste special" screen, but there is anothe
"paste special" screen that comes up when there is a certain type o
data in the clipboard. This screen has options as to what format yo
want to paste the data to. The options I have now are "bitmap"
"Unicode text", and "text". I need to find out how to add csv to tha
list

 

[PokerZan]

Unicode Text should give you the results you desire I believe..

 

[dborski]

Thanks for your answer about unicode text but I've tried that and it
doesn't separate the columns. All the data is in one cell.