I have a spreadsheet with a column that contains explanations for changes in
account values day to day. The cells contain numbers, text and abbreviations
for multiples of 1,000 and 1,000,000. For example, one cell might have the
following:

2.375mm wires, 600k p/i, 100.235mm mkt

Is it possible to create a macro that will remove the text, convert the
numbers to their actual values (2,375,000, 600,000 and 100,235,000) and sum
these? The descriptions might not necessarily be in the order they are above
but the abbreviations and descriptions should be consistant.