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)

CodePudding user response：

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: