Ok here's an excel sheet for an example:Book1.xlsx
So I want a formula in column B to search column A for those listed words and if found, replace those words with what I have next to them in column B. So if found sfo in column A, replace with sf in column B. However, if it doesn't find any of those words listed, simply return what is in column A to column B.
Bookmarks