=8-MATCH(A1,{"A-","A","A+","AA-","AA","AA+","AAA"},0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"ramon" wrote in message
...
I need to convert a list of text values and assign a number code
example:
Text Value Code
A- 7
A 6
A+ 5
AA- 4
AA 3
AA+ 2
AAA 1