If statement help

[Punquey]

I have a table that looks like this:

AL INC.(CCML)

EX, LLC (FF)

TG & A/C (B-FF)

JING & A/C (B-FF)

OKA (B-FF)

EATING & A/C,INC(B-GA)

MECHANICAL AIR SYSTEMS INC

<colgroup><col></colgroup><tbody>
</tbody>

I need to be able to identify the B or the C in the parenthesis of each and name it Boy and Coy in a new column next to the original. I know how to identify (C and tag it, but not sure how to do two items and nest it. Thanks in advance!!

 

[Scott T]

Excel 2010

	A	B
1	AL INC.(CCML)	Coy
2	EX, LLC (FF)	what should happen if it is not B or C
3	TG & A/C (B-FF)	Boy
4	JING & A/C (B-FF)	Boy
5	OKA (B-FF)	Boy
6	EATING & A/C,INC(B-GA)	Boy
7	MECHANICAL AIR SYSTEMS INC	What should happen if there is no ()

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Sheet4​

Copy down. Replace what should happen if it is not B or C and What should happen if there is no () with what you want

Worksheet Formulas Cell Formula B1 =IFERROR(IF(MID(A1,SEARCH("(",A1)+1,1)="B","Boy",IF(MID(A1,SEARCH("(",A1)+1,1)="C","Coy","what should happen if it is not B or C")),"What should happen if there is no ()") <tbody> </tbody>

<tbody>
</tbody>

 

[FDibbins]

here is another approach...
=IF(ISNUMBER(SEARCH("(c",A1)),"Coy",IF(ISNUMBER(SEARCH("(b",A1)),"Boy",""))
copied down