Hello,

I have hundreds of addresses with their postcodes in one cell. I need to split or extract the postcode from the main address and put it into the cell adjacent.

E.G.

I have this in column A:
26, address 1, address 2, address 3, county, postcode

But I need all the postcodes to be in the cells next to their original address in column B.

All of the addresses are formatted differently; some have commas in between the county and postcode and some just have a space.

How can I sort these!?

I would really appreciate if anyone could help.