Home > IT Answers > Microsoft Windows > Extracting Substrings From A Cell in Excel 2003
MrMint
0 pts.
 Extracting Substrings From A Cell in Excel 2003
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!

Software/Hardware used:
ASKED: August 24, 2006  11:00 AM
UPDATED: August 24, 2006  4:24 PM
RELATED QUESTIONS
Answer Wiki:
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)
Last Wiki Answer Submitted:  August 24, 2006  11:41 am  by  Stephen09   15 pts.
All Answer Wiki Contributors:  Stephen09   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanks for the quick response.

The formula works great. It’s just what I needed.

Thanks for your help!

MrMint
 0 pts.