Description
Use this function to return the character specified by a number from the character set used by your computer. Supported in Chains.
CHAR is useful for inserting characters based on their numeric code, such as line breaks, special symbols, or control characters. It's also useful for returning a letter character based on a numeric value.
Syntax
CHAR(number)
Inputs
This function accepts the following arguments:
| Name | Required | Description | Valid input |
|---|---|---|---|
number |
Yes | A number that specifies which character to be returned. | A positive integer, a reference to a cell containing a positive integer, or a formula which results in either of these. The integer must be in the range 1-255. |
Example
Sample data
| A | B |
|---|---|
| 1 | 65 |
| 2 | 66 |
| 3 | 67 |
| 4 | 68 |
Sample formulas
| Formula | Description | Result |
|---|---|---|
=CHAR(A1) |
Returns the character specified by the number in cell A1. | A |
=CHAR(66) |
Returns the character specified by the number 66. | B |
=CHAR(B3+A3) |
Returns the character specified by the sum of the values in cells A3 and B3. | F |
=CHAR(68) |
Returns the character specified by the number 68. | D |
Notes
- CHAR is often used with other functions such as CONCATENATE to insert special characters.
- CHAR can be used to add line breaks in text by using
CHAR(10)(for Windows). - The character set may vary depending on the system, system language, and font used.
Tips
- CHAR is useful for creating dynamic text with special characters in reports and dashboards.
- Combine CHAR with functions such as SUBSTITUTE to manipulate text.
Related functions
CHAR
CODE
CONCATENATE
CONCATENATEIF
FIND
LEFT
LEN
LOWER
MID
PROPER
REPT
RIGHT
SEARCH
SUBSTITUTE
TEXT
TEXTJOIN
TRIM
UNICHAR
UNICODE
UPPER