Identify Cell Currency

[moonlighthd]

I have something like This:
Column A
€45.55
€88.22
$55.22
.
.
€44.88
$77.22

What I want is to know which currency in each cell

like this:
Column A Column B
€45.55 EUR
€88.22 EUR
$55.22 USD
.
.
€44.88 EUR
$77.22 USD

Thanks

 

[Robert Mika]

You need to:
Get a table with currecy and their signs.
(you can use this site:
http://en.wikipedia.org/wiki/List_of_currencies

Copy to Excel.

Use this topic

http://www.mrexcel.com/forum/showthread.php?p=1836832

to get this UDF:

Function GetTextValue(ByVal arg As Range) As String      
GetTextValue = arg.Cells(1,1).Text  '//Cell value (or top left cell value if range is more than one cell) 
End Function

And then use this formula
=VLOOKUP(LEFT(GetTextValue(G2),1),$B$2:$C$279,2,0)

Example attached:

http://www.filesonic.com/file/1732899621/curccency.xlsb

You will have to tairot the table to your needs as there are many countries with $ currency.