How to paste from webpages into cell and remove line breaks in the process?

So I want to copy text from webpages into an Excel spreadsheet. I want to do this without the line breaks from the webpage. IE I want it all in one line in the spreadsheet.

Been trying "paste special" functions and so on to remove formatting, but line breaks stay the same. Any idea on how to do this? I would prefer to do it when pasting, instead of having to apply formulas afterwards, but if formulas is what I need to use, then so be it.

You can probably use Find & Replace more quickly than applying formulae. Highlight the affected cells, then CTRL-H, then:

Find What: CTRL-J
Replace With: <space>
Click Replace All

Hope this helps.

Pete