check a cell to see if it has a currency code

[crmpicco]

i am looking for a function that will check a cell to see if it has a currency code (e.g. GBP) inside it.

[degsy]

You can get a list of international currency codes.

You could add it into a database or textfile array and do a check.

What do you mean by cell? table cell?