[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 506
  • Last Modified:

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
0
Saqib Husain, Syed
Asked:
Saqib Husain, Syed
  • 4
  • 2
  • 2
  • +3
1 Solution
 
magedroshdyCommented:
press F2 on the cell first, then paste (Ctrl+V)
0
 
Saqib Husain, SyedEngineerAuthor Commented:
I am talking about some 27000 lines
0
 
Rory ArchibaldCommented:
I guess you have done a Text To Columns operation recently? You should be able to either just restart Excel or do a TTC operation (on some random data) and specify no delimiters. That should stop the behaviour.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
magedroshdyCommented:
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
0
 
BitsqueezerCommented:
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
0
 
Saqib Husain, SyedEngineerAuthor Commented:
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
0
 
Venkateswarlu KaipuCommented:
Right click and choose PasteSpecial and select Text/ paste values only. then click on ok.
0
 
Saqib Husain, SyedEngineerAuthor Commented:
Venkat, I had already tried that. It did not work
0
 
Venkateswarlu KaipuCommented:
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.
0
 
ghoshsaikat83Commented:
Just close all instances of excel, reopen exel and paste the data. It should be fine...

Joydip
0
 
Saqib Husain, SyedEngineerAuthor Commented:
That is just what Rory said
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 4
  • 2
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now