Paste a line to Excel about ditto HOT 1 OPEN

Use Special Paste --> Remove line feed. I'm not sure, though, if it only removes that last line feed, or removes all line feeds in the clip. But it's worth a try.

Also, in Excel, if you're trying to separate the data into individual cells across, instead of cells down, use the "Transpose" option, after pasting the text, and selecting all the filled cells.

If you want all the data in one long cell, with spaces between words, there is an option to convert the pasted data, and ignore any delimiter such as carriage returns (Enter), line feeds, Tabs, Spaces, and almost any other character. Look under the Data menu and you should find it. Excel may also automatically popup this conversion dialogue when you paste those rows into one cell. It will have line feeds checked by default. Uncheck it and enable Spaces instead. Play around until you get what you want. Depends on your settings and how the rows are formatted. You may also need to add the spaces first (below.)

Last, you may need to use a text editor like Notepad++ or Microsoft Word (maybe even Excel??) to "Find and Replace" (Ctrl+H) line feeds with spaces or Tabs (^T or \t normally.) I think returns are indicated by ^R or ^Q or \r but it's been years since I've done it in Word.

from ditto.