OT Excel query

[N_Cook]

Other than reading the odd XL file I've not had to create/amend an XL
file for decades, but a project requiring active XL tinkering has emerged.
I cannot see how to highlight ,copy as simple text , and paste
individual columns (panes?) from within a worksheet.
ie line breaks at the end of each cell contents, in the column

[N_Cook]

Post by N_Cook
Other than reading the odd XL file I've not had to create/amend an XL
file for decades, but a project requiring active XL tinkering has emerged.
I cannot see how to highlight ,copy as simple text , and paste
individual columns (panes?) from within a worksheet.
ie line breaks at the end of each cell contents, in the column

to paste into likes of Notepad

[GB]

Post by N_Cook

Post by N_Cook
Other than reading the odd XL file I've not had to create/amend an XL
file for decades, but a project requiring active XL tinkering  has
emerged.
I cannot see how to highlight ,copy as simple text , and paste
individual columns (panes?) from within a worksheet.
ie line breaks at the end of each cell contents, in the column

to paste into likes of Notepad

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.

[Fredxx]

Post by GB

Post by N_Cook

Post by N_Cook
Other than reading the odd XL file I've not had to create/amend an XL
file for decades, but a project requiring active XL tinkering  has
emerged.
I cannot see how to highlight ,copy as simple text , and paste
individual columns (panes?) from within a worksheet.
ie line breaks at the end of each cell contents, in the column

to paste into likes of Notepad

I think what you are complaining about is the correct performance. Let
xxx
yyy
zzz
xxx
yyy
zzz
That's what most people would want to happen. However, I think that what
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.

[GB]

Post by Fredxx

Post by GB

Post by N_Cook

Post by N_Cook
Other than reading the odd XL file I've not had to create/amend an XL
file for decades, but a project requiring active XL tinkering  has
emerged.
I cannot see how to highlight ,copy as simple text , and paste
individual columns (panes?) from within a worksheet.
ie line breaks at the end of each cell contents, in the column

to paste into likes of Notepad

I think what you are complaining about is the correct performance. Let
xxx
yyy
zzz
xxx
yyy
zzz
That's what most people would want to happen. However, I think that
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.

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

[N_Cook]

Post by GB

Post by N_Cook

Post by N_Cook
Other than reading the odd XL file I've not had to create/amend an XL
file for decades, but a project requiring active XL tinkering has emerged.
I cannot see how to highlight ,copy as simple text , and paste
individual columns (panes?) from within a worksheet.
ie line breaks at the end of each cell contents, in the column

to paste into likes of Notepad

I think what you are complaining about is the correct performance. Let
xxx
yyy
zzz
xxx
yyy
zzz
That's what most people would want to happen. However, I think that what
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.

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
.

[Jeff Gaines]

Post by N_Cook
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 :-(

[charles]

Post by Jeff Gaines

Post by N_Cook
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 :-(

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

[Jeff Gaines]

Post by charles

Post by Jeff Gaines

Post by N_Cook
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 :-(

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

:-)

[The Natural Philosopher]

Then when I did, it became obvious there was dirt or a dead bug in the
mouse button,

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

[Pancho]

Post by N_Cook

Post by N_Cook
Other than reading the odd XL file I've not had to create/amend an XL
file for decades, but a project requiring active XL tinkering  has
emerged.
I cannot see how to highlight ,copy as simple text , and paste
individual columns (panes?) from within a worksheet.
ie line breaks at the end of each cell contents, in the column

to paste into likes of Notepad

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

[Pancho]

Post by N_Cook

Post by N_Cook
Other than reading the odd XL file I've not had to create/amend an XL
file for decades, but a project requiring active XL tinkering  has
emerged.
I cannot see how to highlight ,copy as simple text , and paste
individual columns (panes?) from within a worksheet.
ie line breaks at the end of each cell contents, in the column

to paste into likes of Notepad

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

Instead of, not Instead or

[Dave W]

Post by N_Cook
Other than reading the odd XL file I've not had to create/amend an XL
file for decades, but a project requiring active XL tinkering has emerged.
I cannot see how to highlight ,copy as simple text , and paste
individual columns (panes?) from within a worksheet.
ie line breaks at the end of each cell contents, in the column

Could you rewrite your last sentence in unde

[SH]

Post by N_Cook
Other than reading the odd XL file I've not had to create/amend an XL
file for decades, but a project requiring active XL tinkering has emerged.
I cannot see how to highlight ,copy as simple text , and paste
individual columns (panes?) from within a worksheet.
ie line breaks at the end of each cell contents, in the column

Could you rewrite your last sentence in understandable English?

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