View Single Post
  #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.