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

--
Message posted from http://www.ExcelForum.com

Use the Asc function. E.g.,

Debug.Print Asc("d")


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



"ExcelMonkey " wrote
in message ...
I know that the Chr function will return a character for a
number. for
example:

?Chr(100)
d


Is there a funciton which does the reverse:

Function("d")
100

Thanks


---
Message posted from http://www.ExcelForum.com/

?Asc("d")
100


--
Regards

Juan Pablo González

"ExcelMonkey " wrote in message
...
I know that the Chr function will return a character for a number. for
example:

?Chr(100)
d


Is there a funciton which does the reverse:

Function("d")
100

Thanks


---
Message posted from http://www.ExcelForum.com/

thank

--
Message posted from http://www.ExcelForum.com