Currency identification

Guest · Aug 15, 2007

I have amounts in a row formatted as USd and AED.Cell A1 200 AED and cell A2
$200.I need to differentiate these two and I should able to capture the USD
alone.The idea is to seperate all the USD.Filter is not working.Please advice.

Guest · Aug 15, 2007

=IF(LEFT(CELL("format",A1),1)="C","USD","EAD")

Guest · Aug 18, 2007

Thanks Tevuna,
This is working.Great.

Tevuna said:
=IF(LEFT(CELL("format",A1),1)="C","USD","EAD")

Currency identification

Guest

Guest

Guest