# ASCII in EXCEL

When you work with Microsoft Excel, you might hear about something called ASCII.

ASCII stands for “American Standard Code for Information Interchange

Think of ASCII as a secret code where every letter, number, and symbol on your keyboard is matched with a special number. This code lets computers and their programs, like Excel, exchange information with each other.

In Excel, you use ASCII to do all sorts of cool things. For example, if you want to find out the ASCII number for a certain character in your spreadsheet, you can use a function called UNICODE.

On the flip side, if you have an ASCII number and you’re curious about which character it stands for, the CHAR function comes into play. These two helpers are like translators between you and the secret language of your computer.

Let’s now have a look at some examples of using ASCII in Excel and see how it can make your Excel calculations more efficient.

## How Excel Interprets ASCII

When you push a key on your keyboard, Excel doesn’t just see the letter or number; it sees an ASCII code.

This code is a number from 0 to 127 that represents characters, including:

• Numbers (0-9): Assigned codes 48 to 57
• Upper case letters (A-Z): Codes 65 to 90
• Lower case letters (a-z): Codes 97 to 122
• Punctuation: Such as `.` (a period), which has the code 46

These codes make it possible for Excel to show you the right letter or symbol on your screen.

## ASCII Codes Table

Below is a table that lists all the ASCII numbers with the characters and the formula to get it.

## Using ASCII in Formulas

In Excel, you can play with ASCII codes to make cool stuff happen in your worksheets. Two handy functions are:

• CHAR(number): Gives you the character for the ASCII code number. If you type =CHAR(65), Excel will show ‘A’.
• CODE(character): Does the opposite, telling you the ASCII code for a character. =CODE(“A”) will give you the number 65.

You can mix these with other formulas in Excel to do things like check if a letter in a cell is uppercase (=CODE(A1) >= 65 AND CODE(A1) <= 90) or to change letters and numbers around in a fun way.

## Using ASCII to Insert a Line Feed in Formulas

Sometimes, when we’re working with formulas, we may need to include special characters. For instance, there are times when we want to insert a line break within a formula. When this happens, we can use ASCII codes.

Below, I have a dataset where I have the names in column A and the titles in column B.

To make name cards in Column C, I want to enter the person’s name first, and then underneath, I want to enter their job title.

To do that I can use the below formula.

`=A2&CHAR(10)&B2`

In the above formula, I have used CHAR(10) to enter a line feed.

`Also read: How to Generate Random Letters in Excel?`

## Using ASCII to Insert Alphabet Letters

ASCII can be used to generate a list of alphabet letters.

Below, I have a table where I have the team number in column A. Now, in column B, I want to assign English letters to each team.

To do that I can use the below formula.

`="Team "&CHAR(65+A2-1)`

In the formula I used, CHAR(65) is what tells Excel to display the letter “A”, and CHAR(66) displays the letter “B”. So, if you’re setting up teams and assigning them letters, you can use these CHAR functions with ASCII codes to generate the letters you need.

## Using ASCII to Create a Bullet List

While Microsoft Word has a built-in feature for creating bullet lists, Excel doesn’t have a direct method for inserting bullets. But you can still achieve this using ASCII codes.

To create a bullet list in column A, I can use the below formula.

`=CHAR(149)&" List "&SEQUENCE(5)`

In the above example, I have used CHAR(149) to insert a bullet point.

## Use ASCII to Insert CheckMarks

Just like inserting bullet points using ASCII codes in Excel, you can also use ASCII codes to insert check marks.

Below, I have a checklist where I have the Project in column A and the progress percentage in Column B.

In column C, I want to enter a tick mark if the progress percentage is equal to 100%.

To do that, I can use the following formula.

`=IF(B2=100%,CHAR(252),"")`

To get the check mark, now I have to change the font type of the formula cells (Cells C2 to C5) to “Windings”.

Other Excel articles you may also like:

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.