How to identify what currency is in cell?

Question

I need function what will return currency type of cell property. Is it possible?

I found only =TYPE(cell) method what return only data type (number, string etc)

Answer 1

there isn't such a function. you will need to try something like:

 =INDEX(IFNA(VLOOKUP(REGEXREPLACE(TO_TEXT(A1:A3), "[0-9, ]", ), 
  {"$", "USD"; "€", "EUR"; "zł", "PLN"}, 2, 0)))

also, you may want to see: https://stackoverflow.com/questions/73767719/locale-differences-in-google-sheets-documentation-missing-pages