CHAR
Returns a single text character, given a character code.
Syntax
Examples
|
Formula |
Result |
|
=CHAR(37) |
% |
|
=CHAR(101) |
e |
|
=CHAR(65) |
A |
Possible Errors
|
Errors |
Meaning |
|
#N/A! |
|
|
#NAME! |
|
|
#VALUE! |
|
|
#REF! |
|
Similar Functions
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Still can't find what you're looking for?
Write to us: support@zohoforms.com
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho SalesIQ Resources
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
CLEAN
Removes the non-printable characters from a given text string. Syntax CLEAN(text) text: The text from which you want to remove all non-printable characters. Remarks The CLEAN function removes the first 32 non-printable characters in the 7-bit ...CODE
Returns the numeric code for the first character in a text string. It's given in the range of 0-255. Syntax CODE(text) text: The text in which you want to obtain the numeric code for the first character. E.g. "Zoho" Examples Formula Result ...Wildcard characters in formulas
Wildcard characters help you search for terms with iterations of single or multiple characters. Wildcards can be used in formulas such as XLOOKUP to include relevant terms in match. Below is the list of wildcard characters and their use cases: ...Regular expressions in formulas
Regular expressions are patterns that can be used to include single or multiple characters in search. While Wildcards can be used for simple searches, regular expressions can be applied for advanced use cases. The patterns used in regular ...SPLIT
Divides the given text by a specified character or string, and places each fragment in the adjacent cells in a row. Syntax SPLIT(text, delimiter, [split_by], [remove_blank]) text: The text to be split. E.g. A2 delimiter: The character(s) by which ...