title: finding by symbol then multipling
body: <p>I have an excel problem. column a contains values EG $123, €123 and £123.
  I want to add a column that will search for the currency symbol then multiply the £ by 1.49 and the € + $ by 1. any ideas?
  Thanks</p>