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