Boolean formula

G

Guest

Need some help.....When a user enters a letter I want it converted to a
number. i.e. A=1 B=2 C=3, etc...

So if the user enters BAD....I want it converted to 214
 
B

Bob Phillips

See responses to previous post.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 

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

Excel Convert word into numbers and back 4
FORMULA 2
convert letters to numbers 3
How to replace text with numbers? (formula) 3
Excel Help to copy information from one row at a time to another sheet 1
Creating a UDF to search a cell's formula 8
Convert Letters to Numbers? 8
Excel columns: Converting numbers to letters and vice versa 14

Top