Re: [libreoffice-users] Split cells in Calc

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 <aboba0@gmail.com> wrote:

> On Sun, Aug 10, 2014 at 7:25 AM, Pat Brown <mistyhaven@gmail.com> 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?
>
> Paddy,
>
> 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: 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