sum a multi-line text and numbers cell

Ahmad

Hello all,

I have a sheet need sum number in multiline cell like:

A1 = 80 GB

A2 = 100 GB and 1 TB

A3 (Total) = 1180 GB or 1.18 TB

Ahmad.xlsx

David Tutwiler

Is there any way to clean up the input coming into this sheet? If you just standardized the input in GB then you could just do a simple sum and then a division that would show your TB at the end.

Ahmad

https://community.smartsheet.com/discussion/comment/269487#Comment_269487

I knot that bro, but this simple of file I have

and also I can use =SUMPRODUCT(--SUBSTITUTE(I4,"GB","")) and the same with change GB to TB

But also need sprite GB and TB to 2 Colum