Reverse of Chr Function

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

I know that the Chr function will return a character for a number. fo
example:

?Chr(100)
d


Is there a funciton which does the reverse:

Function("d")
100

Thank
 
Use the Asc function. E.g.,

Debug.Print Asc("d")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
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

Searching for Alphabetical Characters 3
formattig word paragraphs from excel 5
Verify Canadian Postal Code ~ make the code work 2
VB Send Mail using Thunderbird 6
ActiveCell.Offset(i, 0) = Chr(ActiveCell.Row + 62) returns all A's 4
Deal with text characters that are greater than chr(127) 7
Split data in field on character return 0
combobox, and chr(10) 7

Back
Top