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

Hi :)
It might be possible by saving as a .csv file (possibly losing all the
formulas and certainly all the formatting) and then use a text-editor
to remove some of the commas.

It's not much more elegant and would probably take even longer and
maybe even make quite a mess - but it might be an option!
Regards from
Tom :)


On 28 January 2015 at 17:07, Brian Barker <b.m.barker@btinternet.com> wrote:
> 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