I have an excel spreadsheet with a "Unit Price" column. Some of the prices are in Euro (e.g. €12.34) and some in US dollars (e.g.$45.67).
I want to create a new column containing all prices in US dollars.
By examining a cell, how can I determine whether the price is in Euro or US dollars