Excel Guides

How to Return an ANSI Value in Excel

To return an ANSI value in Excel, you will need to use the CHAR function. This function takes a number between 1 and 255 and returns the corresponding character. For example, if you wanted to return the ANSI value for the letter "A", you would use the following formula:

=CHAR(65)

This would return the character "A".

If you want to return multiple ANSI values, you can use the CONCATENATE function. This function allows you to combine multiple strings into one. For example, if you wanted to return the ANSI values for the letters "A" and "B", you would use the following formula:

=CONCATENATE(CHAR(65),CHAR(66))

This would return the string "AB".

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.