Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove decimals of IP address in excel? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
How do I add a reference line to Excel charts? | Charts and Charting in Excel | |||
How can I asign a number value to a text line in Excel? | Charts and Charting in Excel | |||
goal line in excel chart | Charts and Charting in Excel |