Hello All,
I hope someone can help.
I have a column of cells. Each cell contains some text, and then a number in parenthases, then a comma, and then come text, and then a number in parenthases, This repeats probably as many as 5 times, though some cells have fewer then 5. I want to somehow, if possible, extract JUST THE NUMBERS. I would like ot then Divide the SUM of the numbers by the amount of numbers, to obtain the average of the numbers in parenthases. I am most concerned with not having to manually enter the numbers again.
If anyone has any suggestions, I would appreciate your help tremendously.
Michael
Bookmarks