I need an excel formula or macro for extracting one string of numbers that resides between parenthesis
Posted on 2015-01-23
I have a column of names with corresponding id numbers - I need to extract only the numbers from this column..
Smith, Jane (2342)
Litton, Keely (9890)
Huffman, Rosemary (98999)
Easterling, William (1234557)
Data is in column B and I want them to appear on the same worksheet in column A, right next to the name, on the same row).
What formula should I use, or is there a macro for stripping these numbers out in one easy step?