Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
CoolGuy
 
Posts: n/a
Default 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   Report Post  
Dave O
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove decimals of IP address in excel? riffmastr Excel Discussion (Misc queries) 3 February 2nd 05 06:23 AM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
How do I add a reference line to Excel charts? roswellmike Charts and Charting in Excel 4 January 2nd 05 01:29 PM
How can I asign a number value to a text line in Excel? AIF_GoofyDo2 Charts and Charting in Excel 0 December 6th 04 01:19 AM
goal line in excel chart Warren Lehndorfer Charts and Charting in Excel 1 December 3rd 04 04:38 PM


All times are GMT +1. The time now is 09:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"