Excel Guides

Determining an ANSI Value in a Macro in Excel

When working with macros in Excel, you may need to determine an ANSI value for a particular character. This can be done using the ASC function. The ASC function takes a character and returns the corresponding ANSI value for that character.

To use the ASC function, simply enter =ASC("character") into a cell. For example, if you wanted to find the ANSI value for the letter A, you would enter =ASC("A") into a cell. This would return the value 65, which is the ANSI value for the letter A.

You can also use the ASC function to find the ANSI values for other characters, such as punctuation marks and symbols. Simply enter the character you want to find the ANSI value for into the ASC function. For example, if you wanted to find the ANSI value for the exclamation point (!), you would enter =ASC("!") into a cell. This would return the value 33, which is the ANSI value for the exclamation point.

Once you know how to use the ASC function, determining an ANSI value in a macro is easy. Simply enter =ASC("character") into a cell and Excel will return the corresponding ANSI value.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.