I have column A that has data like this:
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!
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!