Re: [libreoffice-users] Merging columns, not cells

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+unsubscribe@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+unsubscribe@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