in reply to Aligning text and then perfom calculations
Your OP probably is solved by now, but may I suggest some alterations?
a) If the "name" columns are to be equal, you would need only one of them,
b) if a word is present in one of the files,
and missing in the other, you could assume this as a value of zero, resulting in
Update: c) and do the formatting/alignment of decimal points (and sorting, like Kenosis in Re: Aligning text and then perfom calculations) after doing the calculations