Copy/Paste issue into Excel
-
I have started to see a weird paste issue with Excel (I have Office 365). Not sure if this is an Excel issue or a Notepad++ issue.
There is a block of text in CSV format in Notepad++, such as:
apples,oranges,cherries,bananas,grapes
When I paste it into Excel, it gets turned into rows automatically:
apples
oranges
cherries
bananas
grapesThis happens even if I right-click and pick “Paste as Values”. Somehow Excel thinks I want to convert the CSV text into rows - but I just want it pasted into the cell as is. It somehow identifies the text as being in a different format.
I’m not sure where to look to fix this, it’s annoying. Any ideas?
-
I don’t see that happen for me.
However, a possible workaround: After copying from NPP, click the cell, hit F2, and paste – this will edit a single cell, and whatever you paste should all go into that cell. -
Thanks for the suggestion. After the usual searching Google and finding useless answers, screaming, throwing the computer out the window, etc, I rebooted Windows. Problem mysteriously went away. Arrggh!
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login