ExcelBanter - Currency identification

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Currency identification (https://www.excelbanter.com/excel-discussion-misc-queries/154220-currency-identification.html)

Balaji

Currency identification

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.

Tevuna

Currency identification

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

"Balaji" wrote:

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.

Balaji

Currency identification

Thanks Tevuna,
This is working.Great.

"Tevuna" wrote:

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

"Balaji" wrote:

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.

All times are GMT +1. The time now is 04:13 PM.