I need to convert commentaries in excel on financial data from dollars to euros. Rather than manually calculating and converting the numbers and changing the $ sign to €, can I write a macro that extracts numbers from a text string, multiply the numbers by an exchange rate and replace the calculated numbers back to text string? For example: Assuming an exchange rate of 1.48, I would like to change "The variance is made up of project A (+$100m), project B (-$75m) and project C (+$25m)." to "The variance is made up of project A (+€67.6m), project B (-€47.3m) and project C (+€16.9m).”
Thanks in advance for your help.