convert text string to a number code
 

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

convert text string to a number code
 

=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

convert text string to a number code
 

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)

"ramon" wrote:

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

convert text string to a number code
 

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" wrote:

=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

convert text string to a number code
 

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)

"ramon" wrote in message
...
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" wrote:

=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

convert text string to a number code
 

Thank you Bob ...

"Bob Phillips" wrote:

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)

"ramon" wrote in message
...
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" wrote:

=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