How to get total of numbers in a textbox
Can you help me with a function to sum up the total numerical values in a textbox separated by , or carriage return e.g.
If text contained "XS-1000, S-2000, M-3000" what kind of calculation to use to output a value of 6000?
I tried and I am stuck at.
Let(I=PatternCount(text; ",") + 1; Filter(LeftValues(text; i); "1234567890"); i = i -1)
but it only outputs 100020003000
I appreciate your time and help, thank you.