Extracting Substrings From A Cell in Excel 2003

pts.
Tags:
Microsoft Office
Hello, I have an Excel worksheet with a column that contains text data (e.g. part numbers.) The data can vary in length but after each part number, there is a separate number in parenthesis. So a typical cell in this column will look like this: "abcxyz (25)" (minus the quotes.) What I'm trying to do is have a second column to only display the number in the parenthesis from the previous column. So if column A contains abcxyz (25), I want column B to contain 25. What's making this difficult is that the number in parenthesis in column A can be anywhere from 1 to 4 digits long. Is there a function, or series of functions I can use to extract the number within the parenthesis regardless of its length? Thanks for any information!

Thanks. We'll let you know when a new response is added.

Asumming that cell A1 has the value:

abcxyz (25)

Use this formula to extract the 25 –

=MID(A1, SEARCH(“(“, A1) + 1, SEARCH(“)”, A1) – SEARCH(“(“, A1) – 1)