So I am using web query to import data from a web source. These are all either doctors, or facilities. The doctors's names are all imported with last name then first name, ex: SMITH, JOHN. Facilities are not the problem. I want to create an IF statement that will recognize the comma between the last and first name, and then if there is one (because there's only a comma in the doctors's names, not the facilities) to add DR. before the name.
I am then mail merging this to a letter. So maybe it (the word "DR." )doesn't necessarily need to be in the same cell as the doctors's name.



Thanks for checking this out!

Maybe something like this: =IF(ISNUMBER(SEARCH("*dog*",A1)),"dog","")