convert text string to a number code

[Guest]

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

 

[Bob Phillips]

=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)

 

[Guest]

Assuming your text/code table is in columns A & B (A2:B8)and C2 contains
value to be converted:

=VLOOKUP(C2,$A$2:$B$8,2,0)

 

[Guest]

Thank you for the response Bob.
I am not sure how to use that formula, probably because I did not provide
enough detail for my query.
I am trying to create a table that will asssign a numeric value to a list of
characters.

In my example below, I am trying to assign a value of 7 to the alpha value
A- whenever it encounters it in a column of the spreadsheet (let's say column
C ), next I want to assign a value of 6 to the alpha value A whenever it
encounters it in column C ...and so on..
So I want to end up with each occurrence of the alpha value with an assigned
numeric code.
How would the formula be used? and Where would it be placed when using
multiple spreadsheets.? I supposed the value table will be on one spreadsheet
and the formula will be in the column next to where the data spreadsheet.
Thank you again for your help.

 

[Bob Phillips]

If the alpha value is in A1, put the formula in B1, and see what happens.

--
HTH

Bob

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

 

[Guest]

Thank you Bob ...

If the alpha value is in A1, put the formula in B1, and see what happens.

--
HTH

Bob

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