I have a Calc sheet and in a column text strings like:

text1 and text2

text1 and text2 have no space & before and after “and” there is 1 space

I want to create a formula (or apply several) to place text1 in once cell and text2 in the neighboring cell. The “and” and the space are not needed.

I checked the Calc’s text formulas but could not identify one which can help me.

Identification of the number of charactes until the “a” and “d” of “and” would be already of help.

Thanks in advance!