It takes ASCII value as an input number and gives the character associated with that ASCII value as an output.

For each character that can be typed, has a unique integer number associated with it, may it be a character set, digits, punctuation marks, special characters, or control characters.

ASCII values ranging from 097-122 are reserved for the alphabets a-z in lower case.

For example, when we pass 32 as an input, we get a space value as an output.

It can further be used while writing an Excel application or a Macro when dealing with strings and characters.

Let understand the working of (CHAR) CHARACTER Function in excel by some examples.

The user needs to find whether the ASCII values are correct or not and color the incorrect ASCII values using the conditional formatting.

Go to Home- Conditional Formatting - Highlight Cells Rules -Text that Contains.

Further to replace the unwanted character we will use the SUBSTITUTE function in excel.

CFA And Chartered Financial Analyst Are Registered Trademarks Owned By CFA Institute.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

Excel Chr(10) For Mac