In excel, how do you asign numeric values to text or letters, eg..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I asign numeric values for text of letters, eg. A=1, B=2, C=3, etc.
 
Hi
if you have this kind of order try (letter in cell A1):
=CODE(A1)-64
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Asigning a value to words 10
How do I assign a numeric value to a letter 1
assign number value to text 1
Cell Value 1
VBA- Excel Programming:- 0
Counting Upper and Lower case chars in a Cell 7
Array Function to do a Sum of VLookUps that translate a letter gra 3
asign a number to a text string 7

Back
Top