Hi All,
Hope you are well. I am having trouble with a formula, I want to check if a specific address, contains certain words, like STREET, ROAD, RD, COURT etc, but what happens is if an address is listed as SHEPHERD PLACE for example, because it contains RD, it returns TRUE, when I would like to return FALSE as the RD and COURT, STREET, ROAD etc all need to be single words, not contained in a word. I have attached my spreadsheet, please can someone have a look?
Thank you
Bookmarks