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!
August 24, 2006 11:00 AM
August 24, 2006 4:24 PM