How will i know if a certain word exist in cell

[mart_mrexcel]

How will I know if a certain word exist in a cell. Example I want to know whether there is a word like: “Admin” or “Tech” in a cell. If there is word “Admin” then the value will be “A”, if it is “Tech” the value will be “T”. Here’s the tricky part, the caps will not be necessary for checking meaning “Admin” is same as “aDmin”. Help please.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Example: A1 has value text = “Professional “Admin”<o></o>
A2 has value text = “Professional “tech”<o></o>
A3 has value text =”admin” professional”<o></o>

 

[pgc01]

Hi

Try, for ex.:

=IF(ISNUMBER(SEARCH("admin",A1)),"A",IF(ISNUMBER(SEARCH("tech",A1)),"T","Not found"))

 

[mart_mrexcel]

wow that really works...thanks a lot have a nice day

 

[pavin]

Try this formula:

=IF(ISNUMBER(SEARCH("Admin",A1)),"A",IF(ISNUMBER(SEARCH("Tech",A1)),"T",""))

OH!...Mine is similar to Pgc01.,well I was late to respond......