View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Balaji Balaji is offline
external usenet poster
 
Posts: 10
Default 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.