Lovell Mcilwain wrote:
Hello all,
Can anyone tell me how I can split the contents of one cell into
separate cells?
Right now I have spreadsheet that is formatted with city, state and
zip all in the same cell and I need to split it so that cit, state,
and zip have there own cell.
Copy column with data in CALC - spreadsheet.
Open WRITER - text document.Edit - Paste Special - Unformatted text.
Select data then Table - Convert - Text to Table.
In option Separate text at check Other. In box enter (type) space. OK
Copy table back in CALC.
HTH
sasa k.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
