+ Reply to Thread
Results 1 to 2 of 2

How to remove an extra line added by excel when pasting into notep

  1. #1
    CoolGuy
    Guest

    How to remove an extra line added by excel when pasting into notep

    Im copying a cell in excel and pasting the content in notepad. The content
    pasted in notepad automatically having a newline at the end. So the cursor is
    moving to the next line automatically. How to get rid of this problem? I want
    the cursor should be there at the end of that particular line. It looks like
    a small problem. But I copy and paste from excel to notepad at least 1000
    times a day. All the time Im pressing backspace to delete that extra line.
    Can anyone help me here to get rid of this problem?
    How to remove an extra line added by excel when pasting into notepad from a
    cell in excel?

  2. #2
    Dave O
    Guest

    Re: How to remove an extra line added by excel when pasting into notep

    The carriage return occurs when you land the cell pointer on a cell,
    copy it to the clipboard, and paste into Notepad. If you copy from the
    cell editor box (located just above the letters that serve as column
    labels on the worksheet) and paste into Notepad from there, there is no
    carriage return.

    If I may editorialize for a moment, tho, if you're doing this "at least
    a thousand times a day" then you might consider a less manual process:
    perhaps saving the Excel file as text. Some time spent up front to
    automate the process will save you from job burnout, or from repetitive
    stress injuries at the very least.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1