Hi. I am trying to separate an address in to separate columns, which at the momemnt has been wrapped so using the Text to columns is not working.

I have used this formula - =RIGHT(A1,LEN(A1)-FIND(CHAR(10),A1))
which has worked so far in that is has separated each new part away from what went before but it still takes with it what follows it.

For example.

CELL A1 - Address 1, Address 2, City, Postcode
CELL A2 - Address 2, City, Postcode
CELL A3 - City, Postcode
CELL A4 - Postcode

How do I make it so that its:

CELL A1 - Address 1
CELL A2 - Address 2
CELL A3 - City
CELL A4 - Postcode

I'm guessing that it is going to be a slight variation on the formula I have already used. If you have any ideas I would really appreciate your help.

Thanks,

Jen