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.
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.