I have a spreadsheet setup and in one cell there are address details but in
between the address details there is a square symbol.

In some of the cells there are up to 6 different address lines with some
only have 1 or 2 address lines in there.

What I would like it to do is take the text from Initially before the first
symbol and bring that text into an address line 1 cell and then from after
that take the text from just after the symbol to the next symbol and bring
that text through into the next possible cell.

Hope this makes sense.