Snasui Excel Forum

Hi Dear,

I come up with an issue how to add values in single cells but data type not consistent like space and = sign.
I also attached and excel template with result on column b

Thanks

Here's the attached

You can use this formula for example text in your attached file.

=SUM(FILTERXML("<t><s>"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A3," kg","kg"),"="," ")," ","</s><s>")&"</s></t>","//s"))

Thank you