Brian and Rob;
Can you give me an example of a concatenation formula for a column of text
merged with a column of numbers?
The resulting column would have the text and number in one cell.
-----Original Message-----
From: Brian Barker
Sent: Wednesday, January 28, 2015 9:07 AM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Merging columns, not cells
At 06:44 28/01/2015 -0800, Mark Howe wrote:
I can't find help for merging columns or ranges. Is it possible? Merging
cells is so easy, but I hate to have to do it a million times.
I don't think so. You can merge two cells into one. Or a range of
cells into one - so a column or columns into a single cell. But I
don't see any way of merging, say, two adjacent columns into a single
column of cells - other than the piecemeal way you've described. If
you find a way, please let me know!
As a workaround (and as has already been suggested), you can
o Construct a formula to concatenate the contents of each pair of
cells into a new column.
o Cut or copy the result and use Paste Special (no Formulae) to paste
it back over one of the columns.
o Empty the other column?
But you still end up with a single column of populated cells, not a
range of merged cells (if that matters).
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted