But that’s not the only way.
you’re able to also use the CHAR function to display characters in a cell.
What Is the CHAR function in Google Sheets?
CHAR is a Google Sheets function that takes in the character code and outputs the character itself.
The character codes that Google Sheets uses are decimal Unicode numbers.
you’ve got the option to see afull list of the characters and their codes on Wikipedia.
Frankly, it would’ve been easier to pop in MUO than to print it out using CHAR.
you’ve got the option to use CHAR to print out special and even non-printable characters.
Luckily, the CHAR function covers all bases when it comes to characters.
This formula calls onCHARto print out the character with that code.
In this case,10148is the code for a rightwards arrowhead.
you might replace it with any number you want to output as that character instead.
Adding Line Break With CHAR
Another use of CHAR is outputting non-printable characters.
Space and line breaks are two examples of non-printable characters.
Line break is especially useful, as it enables you totype multiple lines in a single cell.
The code for line break is10.
The formula above, for instance, calls onCHAR(10)between the two strings.
As a result, editing text isn’t its strongest suit.
But these limits don’t mean anything once you know how to use the CHAR function in Google Sheets.
The CHAR function allows you to output any character, be it special or non-printable, in your cells.
All you need is the Unicode number for that character to CHAR-ge up your cells!
