remove specific content of a cell to a new cell

[pkinghan]

hi guys

First time here!

I have text data in a cell e.g. "Quantities: 2" or "Quantities: 3" etc. I want to be able to sum the fact that total quantity is 5 and I would normally do this by using text to column feature (fixed width) however is there a way I can extract or move just the number into a new column so i can total that new column?
Thanks

P

 

[gaz_chops]

So if it isn't "Quantities: " in the cells! What actually is in them?