Reverse of Chr Function

[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

 

[Chip Pearson]

Use the Asc function. E.g.,

Debug.Print Asc("d")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Juan Pablo González]

?Asc("d")
100

 

[ExcelMonkey]

thank