Adding numbers within cells that also contain words
Hi
I have an awful feeling that what I am about to ask is not possible but
please have a look.
I have a list of cells which contain:
100 X BLUE BAGS FOR DELIVERY
100 TRADE WASTE BAGS REQUIRED
200 TRADE WASTE BAGS
400 X WASTE BAGS
100 X BLUE WASTE BAGS
etc
but I only want to add the numbers together to see a total amount of bags
ordered but there are quite a few so dont really fancy going through them all
individually to add them so I was hoping there was a simpler way.
Any suggestions would be really greatful
Thanks
Dom
|