I am trying to write a formula to say:
If this cell contains this phrase then have the cell equal ""
I have these values
js = Jan
jdg = John
bhm = Brian
rst = Ryan
kle = Kate
So the cell will contain either one of these abbreviations (js, jdg..etc) and if that cell contains one of them then i want the formula to equal Jan, John..etc.
in english the formula is something like =if((A1=*js*,"Jan"),A1=*jdg*,"John")...etc
The other thing is that the cell that contains the abbreviation also contains other text such as "New Retailer - [JS]" or "New Vendor - [jdg]". so i want to just search for "js" or "jdg" in the cell and if that cell has that value then have it equal Jan or John...etc
Any suggestions....Thank you
Bookmarks