Hello,
I have a spreadsheet in Excel with two columns. In column A there is data that looks like this:
117484 (100), 117486 (26), 162724 (100), 165982 (21), 39759 (56)
I would like to have the total of all the numbers within the parenthesis added and placed into column B, ignoring the larger numbers outside of the parenthesis. Is that possible?
Thanks for your help!
Nick
I have a spreadsheet in Excel with two columns. In column A there is data that looks like this:
117484 (100), 117486 (26), 162724 (100), 165982 (21), 39759 (56)
I would like to have the total of all the numbers within the parenthesis added and placed into column B, ignoring the larger numbers outside of the parenthesis. Is that possible?
Thanks for your help!
Nick