Out of pure curiosity, is there a way to only count numeric values within a cell that also contains text? Would save me a lot of editing if there was.
An example of a cell is this:
PRICE1 - 1500
PRICE2 - 2000
PRICE 3 - 1500
So I would say that cell has a total of 5000. I highly doubt it is possible, but never hurts to ask.
An example of a cell is this:
PRICE1 - 1500
PRICE2 - 2000
PRICE 3 - 1500
So I would say that cell has a total of 5000. I highly doubt it is possible, but never hurts to ask.