Excel 2007 : Extract add numbers from text w/blank cells

Hi all,

I hope someone can help on this one. I am sooo stumped.

I have one column with numbers as text on the left and right separated by "..", i.e.,

4.56..12.01
9.12..0.34
11.67..5.46

This is data that was stored in this fashion and I don't know why. I have about 1500 of these in one column.

I need to add the left-most numbers and the right-most numbers and then a total. Attached please find a sample workbook.

If possible I would really appreciate a formula that can add the numbers on the left and another formula to add the numbers on the right.

Thank you in advance for helping with or just reading this post.