I have a cell that contains a full address e.g. Flat 10, 1 London Road, Bromley, Kent, BR1 1AA. I would like to be able to extract each of the parts of the address that are seperated by a comma.
I have managed to get the first line with:
=LEFT(A1,FIND(", ",A1-1)
And the second with...