PDA

View Full Version : Dynamically look between Paranenthesis



Djblois
04-08-2008, 07:26 AM
When we run reports in my company Product descriptions will come out like this:

B.Kassel SLC (664501)
CELEBRITY CANADIAN STYLE BACON WA SLC 4/3# (6677015)


The number inside the paranthesis is the Product Code. I want to be able to parse the number out of the Paranthesis. I know how to do it if the Product Code is always the same length. Here is the formula I use:

=MID(B2,FIND("(",B2)+1,6)

I want to get this to work with a dynamic Product Code. It can go anywhere from 3 digits up to 8 digits. I think I will have to find the outer paranthesis and tell it between the two but I have not been able to figure it out.

MikeO
04-08-2008, 07:29 AM
=MID(B2,FIND("(",B2)+1,FIND(")",B2)-FIND("(",B2)-1)