OT Excel query

to paste into likes of Notepad

Could you rewrite your last sentence in understandable English?

I think what you are complaining about is the correct performance. Let me see if I understand correctly:

You have a column of cells in Excel that looks like this:

xxx yyy zzz

You highlight, copy, and paste those into notepad, and they look like this:

xxx yyy zzz

That's what most people would want to happen. However, I think that what you want is this:

xxx yyy zzz

So what you need to do is find and replace the line breaks with a space. Sadly, the plain vanilla version of notepad cannot do that.

There are loads of word processors that will do that easily - Word, for example. Or, you can get an upgraded version of notepad called notepad++.

Alternatively, Excel can easily concatenate all the cells in a column into a new cell, and then you can copy that.

Excel does have a transpose feature, so characters in a column can be transposed into a row. Then a copy and past will do the above into Notepad.

Does the OP mean a XML file or a XLS or a XLSX file?

Maybe use Notepad++ instead or notepad? I'm on Linux, but OO Calc and Notepadqq work without doing anything.

Instead of, not Instead or

Agreed. Essentially, the OP needs to sort this out before pasting into Notepad. Alternatively, he needs to use a text editor with more functionality.

Apologies for the query I couldn't find confirmtion of how to highlight because they call it selecting. Then when I did, it became obvious there was dirt or a dead bug in the mouse button, I'd used a pc for this that I'd not powered up for a couple of years .

It's a weakness certainly in Microsoft Bluetooth mice. The left button fails a few weeks after the warranty expires, happened to me half a dozen times :-(

I've had more than one mouse fail to respond to the main button. It's the last thing you think of.. Sympathies..

from a sales point of view, it's perfectly designed

:-)