Hi gurus,

I've been searching for the topic but found nothing relevant. Say
there's a column A like this -

EUR 100
USD 200
CNY 300
YEN 400

How can I get the sum of those values? The currencies were set by
"cell format" so they're not part of the text.

Any input would be appreciated.

Best, Yu