asked on

Paste Comma delimited file without parsing

I am trying to paste a comma delimited file from notepad to excel. The file has data in comma delimited format. The first time I pasted it it was all in one column. But now it always splits the data into columns at the commas. How can I stop this?

Saqib

magedroshdy

press F2 on the cell first, then paste (Ctrl+V)

Saqib Husain

ASKER

I am talking about some 27000 lines

ASKER CERTIFIED SOLUTION

Rory Archibald

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

magedroshdy

the behaivour you're experiance should happen only with .csv file not .xls, anyway you can rename your text file (notepad) to .xls and then open it with ms excel

Bitsqueezer

Hi,

after inserting in Excel (2003 and higher) you see a little paste icon beneath the pasted cells. If you click there you can specify if you want to use the assistant instead. You can use the assistant to enter another sperator as comma so it will not be separated into columns.
As often as I tested it always uses the normal paste instead of the assistant.

Cheers,

Christian

Saqib Husain

ASKER

Yes, Rory, you are right. I did do a TTC operation after which this happened. I did also try to perform a dummy TTC without delimiters and then repeated but it did not work. Maybe I shall try it again. Or maybe reload Excel.

Thanks

Saqib

Venkateswarlu Kaipu

Right click and choose PasteSpecial and select Text/ paste values only. then click on ok.

Saqib Husain

ASKER

Venkat, I had already tried that. It did not work

Venkateswarlu Kaipu

Befor doing the above steps,

Select all the range in destination and set text as number format and try to do

Right click and choose PasteSpecial and select Text/ paste values only. then click on ok.

ghoshsaikat83

Just close all instances of excel, reopen exel and paste the data. It should be fine...

Joydip

Saqib Husain

ASKER

That is just what Rory said