Sceiron
July 10th, 2011, 07:40 PM
Hoi,
im playing around in Excel, does anyone have any tips for how to check if a cell in MS Excel can do the following:
I wanna check if a cell contains "ABC" in a cell with xxx1980
Lets say cell A contains ABC1980 then what I need excel to do:
IF Cell A contains ABC1980
print Yes in Cell B
IF Cell A contains DEF1980
print maybe in Cell B
I have tried with MID function, and CODE function without good results.
any Excel geeks :) ?
Had problems finding compare-functions that looks for charaters..
Thanx
im playing around in Excel, does anyone have any tips for how to check if a cell in MS Excel can do the following:
I wanna check if a cell contains "ABC" in a cell with xxx1980
Lets say cell A contains ABC1980 then what I need excel to do:
IF Cell A contains ABC1980
print Yes in Cell B
IF Cell A contains DEF1980
print maybe in Cell B
I have tried with MID function, and CODE function without good results.
any Excel geeks :) ?
Had problems finding compare-functions that looks for charaters..
Thanx