Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

Thanks Alan. I need to split a single cell and work with it as two cells
(i.e. text as well as background and cell borders). Maybe the only way to
do this is to merge two columns and then split the one cell that I need to
work with. This is rather ham-fisted but may be the only solution.

On 10 August 2014 13:52, Alan B <> wrote:

On Sun, Aug 10, 2014 at 7:25 AM, Pat Brown <> wrote:

Hi Guys,
   Is there any way to split a primary (one that has not been 'merged'
previously) cell?  I can't seem to find such an option. If there is no
current option then is it technically possible to do so?


Presuming cell content is text, the "Data | Text to Columns" operation can
split the text into multiple cells.

For splitting a single cell it may be simplest to use the "Fixed width"
separator option and then mark where to split the cell content.

If there is a column of cells that needs to be split into multiple cells
then either "Fixed width" or "Separated by" depending on cell content would
be the technique to use.

To split up a column of cells as a group each cell in the column would
need similar characteristics re: where the split should be done. e.g. each
cell contains words separated by commas then could use the "Separated by"
option, tick "Comma" and the contents of each cell would be split across
multiple cells at the comma separator.

Hope the above is the kind of solution you're looking for.

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.