Finding Charecters in the cell

[lprabhu1107]

Dear All,

I have following in the cell "OCN3MIN5" in A1 & "ORPXPIN2" in A2 and so on. If "CN" is there in cell A1 i should get yes in cell B1 and if "PIN" is there in Cell B2 i should get yes in cell B2.

can you suggest aIf command to do this

Regards

prabhu

 

[sanrv1f]

Hi Prabhu,

welcome to the board

this will check the cells A1 & A2 for CN & PIN

Excel Workbook
	A	B
1	OCN3MIN5	Yes
2	ORPXPIN2	Yes
Sheet1

Excel 2003

Cell Formulas
Range	Formula
B1	=IF(ISNUMBER(SEARCH("CN",A1)),"Yes","no")
B2	=IF(ISNUMBER(SEARCH("PIN",A2)),"Yes","no")

if the search text is going to vary for each cell, then you need to try a different method

 

[Sektor]

=IF(IFERROR(FIND("CN", A1);"")="", "no", "yes")
=IF(IFERROR(FIND("PIN", A2);"")="", "no", "yes")