If statement help

[Punquey]

I have a table that looks like this:[TABLE="width: 287"]
<colgroup><col></colgroup><tbody>[TR]
[TD]AL INC.(CCML)[/TD]
[/TR]
[TR]
[TD]EX, LLC (FF)[/TD]
[/TR]
[TR]
[TD]TG & A/C (B-FF)[/TD]
[/TR]
[TR]
[TD]JING & A/C (B-FF)[/TD]
[/TR]
[TR]
[TD]OKA (B-FF)[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]EATING & A/C,INC(B-GA)[/TD]
[/TR]
[TR]
[TD]MECHANICAL AIR SYSTEMS INC[/TD]
[/TR]
</tbody>[/TABLE]

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[TABLE="class: grid, width: 500"]
<colgroup><col><col><col></colgroup><tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]AL INC.(CCML)[/TD]
[TD]Coy[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]EX, LLC (FF)[/TD]
[TD]what should happen if it is not B or C[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]TG & A/C (B-FF)[/TD]
[TD]Boy[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]JING & A/C (B-FF)[/TD]
[TD]Boy[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]OKA (B-FF)[/TD]
[TD]Boy[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD]EATING & A/C,INC(B-GA)[/TD]
[TD]Boy[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD]MECHANICAL AIR SYSTEMS INC[/TD]
[TD]What should happen if there is no ()[/TD]
[/TR]
</tbody>[/TABLE]

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
[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="class: grid, width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TD="width: 10"]Cell[/TD]
[TD="align: left"]Formula[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B1[/TH]
[TD="align: left"]=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 ()")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[FDibbins]

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