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!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!