How to devide one text cell into two cells

[Mula]

Hello,
Could you please help me to devide one text cell into two cells?

I have a text in one cell:

Pool H/W Borrow for:Corthesy Carole

How to devide it in a way that:
Pool H/W Borrow
appears in one cell, and:
for:Corthesy Carole
appears in a cell on the right of the first cell

Thank you in advance

[DonkeyOte]

Is "for:" always the determining factor in terms of where the split should take place ... ?

If so run an Edit -> Replace on your present values Replacing for: with ^for:

Now highlight your values and run:

Data -> Text to Columns -> Delimited -> in Step 2 enter ^ into "Other" and click Finish.

[Mula]

Thanks a lot. It works