How to Add 0.12.5 and 0.4.18 in excel-CodePudding

i have a survey report. In that report i have two numbers like 0.12.5 and 0.4.18. how to add these two numbers in excel. i need the result as 0.16.23

CodePudding user response：

This can be solved relatively easily using Text to Columns feature. Use it to chop your input numbers into 3 columns each. Then add them separately and finally join them together using simply string concatenation.

CodePudding user response：

It's also possible without helpers by using FILTERXML to separate the values in an array and add them, then using TEXTJOIN to format them separated by dots again:

=TEXTJOIN(".",,FILTERXML("<x><y>" & SUBSTITUTE(A1,".","</y><y>") & "</y></x>","//y") FILTERXML("<x><y>" & SUBSTITUTE(A2,".","</y><y>") & "</y></x>","//y"))

PS FILTERXML only works on Windows computers.