Hi,
I have many rows of texts with each having a number within brackets. I would like to be able to extract the numbers from the texts, convert to number and sum them to get the total. I understand that the VALUE function can be used to convert text to number. However, I'm not sure how to extract the numbers from text.
Eg: ABC (23)
DEFG (11)
KLM (13)
AK (123)
I want to extract 23, 11, 12 and 123.
Is there a way to do this please?