Convert a character to its ASCII value

[John Kauffman]

I thought (remembered?) it was easy to convert a char to ASCII using ASC() as follows:

Col B is formatted to type=Number
A1 holds "N"
B1 holds =ASC(A1) expected but got "N"

another attempt:
B1 holds =ASCII(A1) #NAME

I searched MRExcel and google for "Excel Convert Character to ASCII" and got no answer.

Anyone know the answer? Thanks.

 

[John Kauffman]

Brilliant. Got it. I did not consider the possibility of a header.
Thanks for explanation.