Can I take a NUMBER from a cell that also has text in it and sum it?

D

daviddschool

I made a survey but realised too late that I have A NUMBER ( like 2)
and TEXT in the same cell. I now want to SUM up the cell, but saw
that it doesn't work. Is there a way to format the cell or to just
take the number and add it ignoring the text?
 
Top