View Single Post
Old 08-17-2009, 09:55 AM
themangoagent themangoagent is offline Windows XP Office 2003
Join Date: Jul 2009
Posts: 9
themangoagent is on a distinguished road
Default 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?
Reply With Quote