Community
    • Login

    Copy/Paste issue into Excel

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    3 Posts 2 Posters 1.8k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Jeff HaasJ
      Jeff Haas
      last edited by

      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
      grapes

      This 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?

      1 Reply Last reply Reply Quote 0
      • PeterJonesP
        PeterJones
        last edited by

        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.

        1 Reply Last reply Reply Quote 0
        • Jeff HaasJ
          Jeff Haas
          last edited by

          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!

          1 Reply Last reply Reply Quote 0
          • First post
            Last post
          The Community of users of the Notepad++ text editor.
          Powered by NodeBB | Contributors