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