I wish to extract the town from this address which has been downloaded from the internet.
Example address:
Craven Buildings Craven Street, Skipton. BD23 2AP
Each town commences with 2 spaces after a "," and finished with a ".". I have attempted to use the MID function to extract the date but cannot work out how to cope with the length of the town name changing.
Can someone please assist?
Bookmarks