Extract last words in cell

[Shaz]

Hi all,
I need some help.
I have to import lists that look like that below and need to extract
to seperate cells the words/letters after the postcode (BA5 2AA etc).
In the first example H and No will move to seperate cells, Deleted and
No likewise and H No and 04/07/2003 likewise. The full address up to
the postcode will remain.
Any help as always much appreciated.

10, First ROAD, MEXLEY, KENT BA5 2AA H No
HENLEYS, Yellow ROAD, Bromley, KENT ZA3 2AS Deleted No
MANOR Road HOUSE, Dirt ROAD, Grays, Essex BD4 3LX H No 04/07/2003


Thanks

 

[Frank Kabel]

Hi
based on this example data I doubt this is really possible.
Problem: It is not the last word to remove but you can have different
numbers of words after your postcode. How should one identify the
postcode as there's no fix position or other identifier to get this
data.

 

[Shaz]

Hi Frank
Thanks for the reply.
Is it possible to extract all the words from right to left to seperate
cells based on the last word that has a trailing comma? I can then
"add" back the County and Postcodes?
Example KENT BA5 2AA H No, Essex BD4 3LX H No 04/07/2003

TIA
Shaz

 

[Frank Kabel]

Hi
in this case have a look at 'Data - Text to columns'