Finding ASCII value of a character

M

mario

What is the function to find the ASCII value for a
character in ACCESS like 'A' is 65/63 or what ever

Please help

thanks
mario
 
G

Gord Dibben

Mario

This is an Excel News Group. Are you sure you're in the right place?

If Excel you can enter this formula in A1 and drag/copy down column A to row
255.

=CHAR(ROW())

Change the Font Format for that column to various fonts to see characters
associated with a number.

Gord Dibben Excel MVP
 
J

James Silverton

Gord Dibben said:
Mario

This is an Excel News Group. Are you sure you're in the right place?

If Excel you can enter this formula in A1 and drag/copy down column A to row
255.
Click to expand...

The reverse, finding the code to insert a character, can be done in later
versions of Excel by using Insert Character. As I mentioned a few hours ago,
Insert Character can be used in Word in some earlier versions where it is
not available for Excel. if you do not have a tabulation of the codes.
 

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

Convert Cell Value to ASCII 2
Conditional Pagebreaks in Mailmerge 2
function to find ASCII Value 1
Querying for Extended ASCII Characters 1
Difficulty cleaning some char(63) characters 1
How do I find non-ASCII characters hidden in text? 1
Macro to Select text from a point given to a specific word 2
Small Thick "Bar" Below Last Typed Line ? 0

Top