Hi, I have listed of data e.g.
Cell A1 - B100 26 Church Ponds CO9 3BZ add new box
Cell A2 - G4 add new meter 15 Highfield Road CV1 1AA
Cell A3 - Product 1000 27 Low Road L1 1AA increase supply
Cell A4 - CF11 1AA 2 New Street g7 remove roof
In cells B1 to B4 I wish to pull out the postcode
B1 CO9 3BZ
B2 CV1 1AA
B3 L1 1AA
B4 CF11 1AA
How can I do this?
Thanks in advance for your help.
Cell A1 - B100 26 Church Ponds CO9 3BZ add new box
Cell A2 - G4 add new meter 15 Highfield Road CV1 1AA
Cell A3 - Product 1000 27 Low Road L1 1AA increase supply
Cell A4 - CF11 1AA 2 New Street g7 remove roof
In cells B1 to B4 I wish to pull out the postcode
B1 CO9 3BZ
B2 CV1 1AA
B3 L1 1AA
B4 CF11 1AA
How can I do this?
Thanks in advance for your help.