Excel Guides

Converting to ASCII Text in Excel

When you want to convert text to ASCII code in Excel, there are a few different ways that you can do it. One way is to use the CHAR function. The CHAR function takes a character and returns the ASCII code for that character. For example, if you wanted to get the ASCII code for the letter A, you would use the following formula:

=CHAR(A1)

If you wanted to get the ASCII code for a string of text, you could use the following array formula:

=CHAR(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))

You could also use the CODE function to get the ASCII code for a character. The CODE function is similar to the CHAR function, but it takes a character and returns the numeric code for that character. For example, if you wanted to get the ASCII code for the letter A, you would use the following formula:

=CODE(A1)

If you wanted to get the ASCII code for a string of text, you could use the following array formula:

=CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))

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.