Scraping text starting with specific character

[Greymud]

I have column A that has data like this:

LOCATION

LINCOLN (WING01-FLR01-RM15)

SIOUX CITY (WING02-FLR03-RM27)

FRAMINGHAM (WING01-FLRB2-RM52)

In the next column, I would like to display the first 12 characters after the (. I was doing fine until I got to the variable length before the ( and I can't figure out how to shift over. I was using

=LEFT(RIGHT(A2,18),12)

but then I found the city names weren't all the same length (who would make them like that? HA!). I googled an example using FIND for something similar, but I can't figure out how to blend the two. I'm trying the following, bit it's not right when it looks like it should be.

=LEFT(A3,FIND("(",A3)+12)

I may be in sideways and can't see the easy fix, possibly I'm doing this the hard way and don't know about the right function to use.

Any help would be appreciated!

 

[GraH]

Maybe =MID(B3,FIND("(",B3)+1,12)

 

[Greymud]

Thanks, GraH! Exactly what I needed.

I probably should have known that if there's a LEFT and a RIGHT, there should be a MID.

 

[GraH]

Maybe you should have had. ?

 

[Bo_Ry]

You may try

=LEFT(RIGHT(A2,18),12)