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.bar...@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+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
