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!

Answer Wiki

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)

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • MrMint
    Thanks for the quick response. The formula works great. It's just what I needed. Thanks for your help!
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following