Collecting and adding all Numbers in a cell
I need to collect and add all numbers in a cell - the problem is there are also letters and signs in that cell and I do not know how many numbers, letters and signs the cell has (all I know is the numbers are between 1 and 9), e.g.:
"Mo1/1" -> result shall be 2
"1A-3(team) & 4" -> result shall be 8
"1 (max) + 5 team) + 8GL(?)" -> result shall be 14
I thought about checking every digit via the functions len(), left() and Isnumber() but then I would end up with a very long IF-formula and the amount of digits in my cells that are beeing checked would be limited to the length of my IF-formula.
Is there a better way?
Thanks in advance! :)
Help Article Resources
Check out the Formula Handbook template!