Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
Convert a number to a name string | Excel Worksheet Functions | |||
Convert text strings to a code or number | Excel Worksheet Functions | |||
How to COnvert text string to number | Excel Discussion (Misc queries) | |||
convert string to number | Excel Worksheet Functions |