Formula to search any part of a string

[*shudder*]

Hi Guys,

I have tried searching however I cannot find anything suitable to resolve my issue.

In column A I have text strings, I would like a formula in an adjacent column that will search any part of the string for "eng", if it is present I would like to have "Yes" appear, if not "No".

Thanks in advance.

 

[JamesW]

Hi,

Try:

=IF(ISNUMBER(SEARCH("eng",C2,1)),"Yes","No")

 

[*shudder*]

Thanks James, worked a treat

 

[jim may]

Another way...

Excel Workbook
	A	B
1	abc	No
2	bde	No
3	jENG	Yes
4	kkp	No
5	hgengppp	Yes
Sheet1

Excel 2007

Cell Formulas
Range	Formula
B1	=IF(ISERROR(SEARCH("*eng*",A1,1)),"No","Yes")

 

[*shudder*]

Thanks Jim, theres more than one way to skin a cat!

 

[jim may]

Thanks Stuart for your response. Glad you took the time to see and understand that point. Too often people come here for a quick answer, and that's all they want. They are not interested in learning anything. More and more, I'm beginning to ignore them.
Jim

 

[*shudder*]

I preferred your suggestion as I can understand the syntax by using ISERROR where you get a #VALUE result from just using the 'search' element of the formula.

I know where your coming from, I do try to help people on here on occasion when my limited knowledge can offer a solution and you have helped me many times in the past. I have also bought several books and do try to resolve/understand the how's & why's.

Thanks again for your suggestions which always provide a resolution (both with formula's and VBA).

Stuart