: Brian Barker
Sent: Wednesday, January 28, 2015 8:02 PM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Merging columns, not cells
At 18:01 28/01/2015 -0800, Mark Howe wrote:
Can you give me an example of a concatenation formula for a column of text
merged with a column
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.
Mark W. Howe
San Juan Capistrano, CA
949-496-3453 home/ office
949-525-3914 cell [not for messages]
Phao Binh
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
Mark,
With merging I assume you mean concatenating the strings into one column...
I generally put a concatenate formula in a separate column, then select cut
that complete column and special past values to the desired column.
Rob.
Op 28 jan. 2015, om 15:44 heeft Mark Howe het volgende
@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
At 18:01 28/01/2015 -0800, Mark Howe wrote:
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.
You can concatenate values using the CONCATENATE() function or - more
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