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
On Fri, 24 Jan 2025 16:39:17 +0000, N_Cook <[email protected]> wrote:
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?
On 24/01/2025 16:39, N_Cook wrote:
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
On 24/01/2025 17:03, N_Cook wrote:
On 24/01/2025 16:39, N_Cook wrote:
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.
On 24/01/2025 16:39, N_Cook wrote:
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
On 1/24/25 17:03, N_Cook wrote:Instead of, not Instead or
On 24/01/2025 16:39, N_Cook wrote:
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.
On 24/01/2025 17:31, GB wrote:
On 24/01/2025 17:03, N_Cook wrote:
On 24/01/2025 16:39, N_Cook wrote:
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.
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.
On 24/01/2025 17:03, N_Cook wrote:
On 24/01/2025 16:39, N_Cook wrote:
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.
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
Then when I did, it became obvious there was dirt or a dead bug in the
mouse button,
On 25/01/2025 in message <vn296q$2nrp1$[email protected]> N_Cook wrote:
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 :-(
In article <[email protected]>,
Jeff Gaines <[email protected]> wrote:
On 25/01/2025 in message <vn296q$2nrp1$[email protected]> N_Cook wrote:
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
| Sysop: | Keyop |
|---|---|
| Location: | Huddersfield, West Yorkshire, UK |
| Users: | 715 |
| Nodes: | 16 (2 / 14) |
| Uptime: | 39:28:29 |
| Calls: | 12,109 |
| Files: | 15,006 |
| Messages: | 6,518,388 |