Summing multiple values in a cell

How do I sum multiple values in a cell. When I use the column Number, I could only insert one value into the form when I need to insert multiple values. When I do the text format, there is an apostrophe that blocks me from getting the sum. Reason why I am asking is because I am working on a project that gets the weight of multiple items in one cell separated by a comma, and I need to find the total weight from these separated values. 

0 3 193
3 REPLIES 3
Top Labels in this Space