IF statement that adds text to a cell
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","")
Last edited by themangoagent; 08-17-2009 at 09:59 AM.
Reason: Found an IF statement that might work?
|