Hi all i am currently working on improving things at the work place and want a specific formula.
The scenario is many depots enter information through a software called K8 which means they can type in anything and is not conistent as there are hundreds of depots, so lots of different people will be entering information. I export the data and then have to manually type each depot (location)
I want to be able to take certain words out of the text they type in in relation to another list.
For example....
depot 1 - 200 cash banbury
depot 2 - cash for radcliffe
depot 3 - Oak hall cash transfer
I want to take out the locations only, is there a way i can use the list of depots 600+ to look up the string entered by the depot and extract only the word I am looking for, The LEFT and MID functions would not work as the location can be anywhere in the text.
Any help?
I hope i have explained well enough.
THANKS!!!!
Bookmarks