total that are of various currency

[zoharb]

I have the list of total that are of various currency($, GBP, AUD, NZD) (and so they are in text) format). Is there way to get the total of that in that particular currency and total of all that in USD.
Eg

artwork	AUD39.95
artwork	Aud 139.95
artwork	4.95​
artwork	3.2₤
artwork	6.4₤
artwork	1.6₤
artwork	A$69.95
artwork	NZD79

 

[SanjayGMusafir]

share XL2BB of actual data to understand the situation. Then only I can tell if there is a solution or not.

 

[Dave Patton]

T202401a.xlsm
	A	B	C	D	E	F	G
1			AUD
2	artwork	AUD39.95	39.95
3	artwork	Aud 139.95	139.95
4	artwork	4.95		4.95
5	artwork	3.2₤			3.2
6	artwork	6.4₤			6.4
7	artwork	1.6₤			1.6
8	artwork	A$69.95				69.95
9	artwork	NZD79					79
4c

Cell Formulas
Range	Formula
C2	C2	=--RIGHT(B2,5)
C3	C3	=--RIGHT(B3,6)
D4	D4	=B4
E5:E7	E5	=--LEFT(B5,LEN(B5)-1)
F8	F8	=--MID(B8,FIND("$",B8)+1,99)
G9	G9	=--MID(B9,FIND("D",B9)+1,99)