Hi,

In a column of data, in excel, I have a mix of currencies.
Some cells contain US$ and some contain Euro like below:
$123.00
345.00 Euro

I need to identify which cells are in Euro so that I can apply a
currency conversion, but cannot find a solution.

I've tried using FIND("$",CellX), but to identify the US$ amounts, but
this did not work as when I click into CellX I see that it does not
actually contain "$"; the formatting has presented it as US$.

I've also tried changing the column format to TEXT, but this did not
work because I lost the currency symbols.

Any help would be greatly appreciated.

Thanks,

Ciarán