ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to remove an extra line added by excel when pasting into notep (https://www.excelbanter.com/excel-discussion-misc-queries/15667-how-remove-extra-line-added-excel-when-pasting-into-notep.html)

CoolGuy

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?

Dave O

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.



All times are GMT +1. The time now is 08:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com