Hi Kimberlie,
One of the MVP's may disagree with me, but I think you have some work ahead
of you. I would use EDIT, REPLACE to change all the x's for nothing, then do
it again to replace all the " with nothing, and do it again for any other
extraneous symbols you have in the cells. Once you just have numbers and
spaces, you can use Text to Columns to de-concatenate (parse) the data. From
there you can perform the maths you want.
Sorry I can't be more helpful
Regards - Dave.