Extract Text in Parentheses From One Cell to Another

I am needing to extract some text in parentheses in one cell and move it to another cell. The data all starts with a description, some text in the first set of parentheses, then some more text in another set of parentheses. Some cells of data only have one set of parentheses and others have two sets of parentheses. All have varying numbers of chracters within the first and second set of parentheses. I am trying to write a formula to only extract the data in the second set of parentheses, (always the parentheses to the far right) excluding the parentheses to move to another cell.

Examples:

Epoxy Pavement Marking (Low VOC Solvent Base) (0200-627-00012 - PVMNT)
Striping Mobilization (0185-62600000 - MOB)

Desired Results:
Example #1: B12: Epoxy Pavement Marking (Low VOC Solvent Base) C12: 0200-627-00012 - PVMNT
Example #2: B13: Striping Mobilzation C13: 0185-62600000 - MOB

My data in the spreadsheet always starts with B12, if that helps to write the specific formula.

Thanks in advance for the help....

Thanks for the reponse, my data is actually starting in B12, but I changed the formula to reflect that. Either way, I want the result to move to C12, (no problem if it needs to be split to C12 and D12) Both formulas are giving me the "#VALUE!" error. I was expecting the formula to start from the right and move to the left looking for the first set of parentheses and moving or copying that data.

Any ideas?

Apparently you didn't catch the edit.

Column C:
IF(LEN(B12)-LEN(SUBSTITUTE(B12,"(",""))=1,LEFT(B12,FIND("(",B12)-2),LEFT(B12,FIND("(",B12,FIND("(",B12)+1)-2))

This should work for column D:
=IF(LEN(B12)-LEN(SUBSTITUTE(B12,"(",""))=1,MID(B12,FIND("(",B12)+1,FIND(")",B12)-FIND("(",B12)-1),MID(B12,FIND("(",B12,FIND("(",B12)+1)+1,LEN(B12)-FIND("(",B12,FIND("(",B12)+1)-1))

Ah ha, I did not catch the edit. Fantastic, that worked great. Thanks for the help.

In using the formula provided yesterday the formulas worked great but in testing it with my data I have ran into a few issues. In some rows of data I was mistaking by saying there are sometimes only one set of parentheses and other times two sets. There are sometimes three and four sets of parentheses. The data I am needng to extract and move to the adjacent cell is always in the far right parentheses. Would it be possible to write the formula to look from the right and move to the left, moving the data in the first set? Also, the other issue I am having is that some of my lines of data do not have parentheses at all. In this scenario, the result from the current formula written is giving me "#VALUE!" in both cells. Would it be possible to include some sort of an "If" statement to solve this problem?

Below are some examples of the data that gets dumped from another program and the variables I am running into:

Cell B12: 2" MILLING
Cell B13: Rem Pavement Marking (0015 - 202-00250 - Rem...)
Cell B14: Pvmt Mkg Paint (Low VOC Solvent Base) (0210 - 627-00012 - Pvm...)
Cell B15: Preform Plastic Pvmt Mkg (Ty II)(Inlaid) (0220 - 627-02010 - Pre...)

Desired Result:

Cell B12: 2" MILLING Cell C12: *BLANK*, or a #VALUE! would be fine, but I need the data to remain in B12
Cell B13: Rem Pavement Marking Cell C13: 0015 - 202-00250 - Rem...
Cell B14: Pvmt Mkg Paint (Low VOC Solvent Base) Cell C14: 0210 - 627-00012 - Pvm...
Cell B15: Preform Plastic Pvmt Mkg (Ty II)(Inlaid) Cell C15: 0220 - 627-02010 - Pre...


From these cells, I am trying to extract the data from just the far right set of parentheses, excluding the parentheses themselves into another cell using a formula. As you can see from the examples, not all of the data has parentheses, some have one set of parentheses, some have two sets, and others have three sets. Fortunately the the data does always have the same number of characters if that helps.

Thank you in advance.

That is exactly right. There is never any further text after the desired data I am trying to extract, the program I am dumping the data from always abreviates as shown and there is never another set of parentheses or any other data to the right.

That worked perfect as far as copying the correct information to the designated cells. Can this be done to then remove the data and set of parentheses I copied from the original cells? This formula left the original data in B12, B13, and so on....

I have similar question what aboout if a cell does not contain parentheses but the next cell contains it , can i place two checkes in excel that if parantehsis is present extract what is inside ,if parantheis is not there copy the noraml text i want to define two conditions how i can do it my formula for extracting parentheses is working as follows but if skips the cell which dont have parentheses and the row becomes empty

=IFERROR(MID(Z2, SEARCH("(", Z2)+1, SEARCH(")",Z2)-SEARCH("(",Z2)-1),"")

Also I have another formula in another column to check two subnets if any IP falls unders that range it display type as Fortinet VPN , I want to keep this condition +above together with a third condition in excel to generate the result

=IF(OR(ISNUMBER(SEARCH("10.179.26",Z2)),ISNUMBER(SEARCH("10.179.27",Z2))),"Fortinet VPN","")

can you guys help ?