Excel formatting for currency identificton

[hudson andrew]

Hi all,

Can someone help me the code that helps me to identify my column “A” with multiple currency signs as format and I want it to read currency format and put the currency sign in column “B”



Curreny Example
₹1,500,000.00 INR
€550.00 EUR
€1,500.00 EUR
£110.00 Pound
£110.00 Pound
₹150,000.00 INR
₹150,000.00 INR
€200,000.00 EUR
€34,577.00
£59,350.00
£59,350.00
€54,246.00
S$60,000.00
₹150,000.00
HK$259,375.00 HKD
HK$259,375.00
HK$259,375.00
S$30,000.00
S$30,000.00
€85,000.00
€85,000.00
€0.00
€500,000.00
€90,878.00
€80,000.00
€60,006.00
€60,006.00
Fr.60,587.77
€70,000.00
₹4,500,000.00
€500,000.00
€150,000.00
HK$250,000.00
S$35,678.00
S$24,678.00
₹500,000.00
₹500,000.00
€10,000.00
HK$250,000.00
€30,000.00
€53,000.00
€53,000.00
$100,000.00
£76,085.00
руб10,000.00
₹2,786,900.00
₹2,786,900.00
€204.00
₹4,500,000.00
€65,000.00
€30,000.00
€75,000.00
€87,500.00
€87,500.00
€500.00
€180,000.00
¥1
¥1
¥1
€53,000.00
€53,000.00
Fr.75,000.00
₹2,000,000.00
₹2,000,000.00
₹2,000,000.00
€65,000.00
Fr.67,568.00
€12,000.00
€12,000.00
$45,000.00
₹750,000.00
€750.00
€30,000.00
€73,000.00
€82,051.28
€102,564.10
£59,500.00
£59,500.00
£59,500.00
HK$150,000.00
HK$150,000.00
€45,000.00
₹195,000.00
₹195,000.00
$1,500.00
$1,500.00
$1,500.00
zł20,000,000.00
€643.44
$10,000.00
₹2,800,000.00
₹2,800,000.00
₹150,000.00
€0.00
€750.00
руб2,200,000.00
руб2,200,000.00
$2,000.00
$150,000.00
$1,000,000.00
$25,678.00
£61,850.00
£61,850.00
£61,850.00
£61,850.00
£61,850.00
£36,104.00
$120,000.00
$120,000.00
¥1,000,000
¥1,000,000
₪40,758.50
€10,000.00
$10,000.00
$20,000.00
S$20,000.00
€100,000.00
€10,000.00
$150,000.00
€90,878.00
S$35,678.00
Fr.45,675.00
€78,900.00
₹10,000,000.00
$200,000.00
€750.00
S$625,000.00
€30,000.00
€30,000.00
€78,900.00
£45,100.00
£45,100.00
£45,100.00
£45,100.00
HK$25,788.00
₹10,000,000.00
₹500,000.00
€54,246.00
€10,000.00
₨100,000.00
Fr.10,000.00
10,000.00.ر.س
kr10,000.00
R10,000.00
€15,000.00
HK$25,788.00
¥247,788
HK$250,000.00
€87,750.00
€76,920.00
€76,920.00
€60,006.00
₹1,000,000.00
Fr.56,856.00
€100,000.00
€180,000.00
$34,876.00
$32,000.00
$32,000.00
$32,000.00
$32,000.00
₹150,000.00
₹150,000.00
R$10.00
€69,305.00
€0.00
$300,100.00
$300,100.00
$300,100.00
$300,100.00
$300,100.00
£60,100.00
£60,100.00
£60,100.00
$85,000.00
€0.00
€100,000.00
€100,000.00
€30,000.00
€54,676.00
£59,509.16
€78,900.00
10,000.00.د.إ
₴10,000.00
₺10,000.00
€10,000.00
$150,000.00
€70,000.00
€1,530.00
$120,000.00
€66,666.67
€80,000.00
$80,000.00
$80,000.00
$45,000.00
₹1,000,000.00
€65,000.00
€44,543.45
€500.00
€65,000.00
₹475,000.00
₹475,000.00
HK$25,788.00
€0.00
€32,500.00
S$50,000.00
€65,000.00
€65,000.00
€85,000.00
€65,000.00
S$20,000.00
€65,000.00
€65,000.00
€14,000.00
₹10,000.00
₹10,000.00
€100.00
₹15,000.00
₹15,000.00
£1,000,000.00
Kč10,000.00
€10,000.00
€625.00
₹200,000.00
€10,000.00
$1,750.00
$1,750.00
$1,750.00
€1,241.20
€1,241.20
€1,241.20
₹25,000,000.00
₹25,000,000.00
₹5,750,000.00
₹5,750,000.00
£60,660.00
£60,660.00
€10,000.00
€10,000.00
S$3,500,000.00
£59,509.16
HK$35,789.00
$900,000.00
£98,735.00
£98,735.00
S$546,000.00
€30,000.00
HK$97,579.00

[hudson andrew]

for example like below .


Currency Currency sign example in coumn B
€0.00 EUR
¥1 JPY
£110.00 pound
€625.00 EUR
$1,500.00 USD
₹5,750,000.00 INR
HKD 500.00 HKD
SGD 600.00 SGD

[kersplash]

Can you attach a sample workbook with some data in it and what you want to see as your result?

[jindon]

UDF
Used in cell like

=GetCurrSymbol(A1)

The result will be the Currency Symbol, so you will need a look up table to get the country.

Please Login or Register  to view this content.

[hudson andrew]

It worked like a charm

[jindon]

You are welcome and thanks for the rep.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.