View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ramon ramon is offline
external usenet poster
 
Posts: 4
Default 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