No csv format in Paste Special

Thank you for your reply. You are correct in that there is no csv option on the initial "paste special" screen, but there is another "paste special" screen that comes up when there is a certain type of data in the clipboard. This screen has options as to what format you 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 that list.

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

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.