Text
TEXTBEFORE
Returns the text that occurs before the specified text/string. Syntax TEXTBEFORE(text; delimiter; [instance]; [mode]; [match_end]; [if_not_found]) text: The text given as input. Eg., A2 delimiter: The text before which the result string is to be ...TEXTAFTER
Returns the text that occurs after the specified text/string. Syntax TEXTAFTER(text; delimiter; [instance]; [mode]; [match_end]; [if_not_found]) text: The text given as input. Eg., A2 delimiter: The text after which the result string is to be ...TEXTSPLIT
Splits the given text string by columns and rows based on the specified delimiter. Syntax TEXTSPLIT(text; col_delimiter; [row_delimiter]; [ignore_empty]; [mode]; [fill_with]) text: The text string given as input. Eg., A2 col_delimiter: The text by ...ARRAYTOTEXT
Combines the given range of values into a single array of text values irrespective of the source format. Syntax ARRAYTOTEXT(array; [format]) array: The cell range containing the values to consolidate. Eg., A2:A5 format: The format in which the result ...NUMBERVALUE
Converts the given text into number using the specified delimiters. Syntax NUMBERVALUE(text; decimal_separator; group_separator) text: The text to be converted in to a number. Eg., "1.000,09" decimal_separator: The character used as a decimal ...VALUE
Returns a number, given its text representation. Syntax VALUE(text) text: The text or range containing the text you want to convert. E.g. "1/2/2020" Examples Formula Result =VALUE("1/2/20") 43832 =VALUE("$5") 5 =VALUE("21:00") 0.875 Get a ...UPPER
Returns the given text with all characters converted to uppercase. Syntax UPPER(text) text: The text you want to convert to uppercase. E.g. "Zoho Sheet" Examples Formula Result =UPPER("Zoho Sheet") ZOHO SHEET =UPPER(A3) SPREADSHEET ...TRIM
Removes all spaces from a given text string, except for the single spaces between words. Syntax TRIM(text) text: The text string given as input. E.g. A2 Examples Formula Result =TRIM(A2) Zoho Sheet =TRIM(" Hello! ") Hello! =TRIM(A4) ...TEXTJOIN
Combines the text from multiple given ranges or strings with a specified delimiter separating them. Syntax TEXTJOIN(delimiter; ignore_blank; text; [text1];...) delimiter: A text string, either an empty one or that with one or two characters. E.g. ...TEXT
Converts a number into text according to a given format. Syntax TEXT(number; format) number: The number you want to convert into text. E.g. "21:00" format: A text string that indicates the format to apply to the text returned. "h AM/PM" ...T
Returns the text string corresponding to the given value or the selected range. Syntax T(value) value: The text string to return. E.g. "Zoho Sheet" Remarks The T function returns an empty text if the given value is not a text string. Zoho ...SUBSTITUTE
Replaces an existing text string with another given text string. Syntax SUBSTITUTE(original_text; old_text; new_text; [which]) original_text: The text to search for the given text string. E.g. "Zoho Sheet" old_text: The existing text string you ...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 ...SEARCH
Returns the position of a given character or text string in a given text string. Syntax SEARCH(find_text; to_search; start_position) find_text: The character or text string you want to find. E.g. "e" to_search: The text in which you want to ...RIGHT
Returns a specified number of characters from the end of the given text string. Syntax RIGHT(text; number) text: The text given as input. E.g. "Zoho Sheet" number: The number of characters to return. E.g. 2 Remarks The RIGHT function returns an ...REPT
Returns a given text repeated the specified number of times. Syntax REPT(text; number) text: The text to repeat. E.g. "Zoho" number: The number of times you want to repeat the text. E.g. 3 Remarks REPT function returns an empty text when the ...REPLACE
Replaces part of a text string with another given text string. Syntax REPLACE(original_text; start_position; length; new_text) original_text: The text, part of which you want to replace. E.g. "Mick Foyd" start_position: The position where the ...PROPER
Returns a text string with the first letter of each word capitalized, and all the other letters in the lowercase. Syntax PROPER(text) text: The text string given as input. E.g. "zOho sheet" Examples Formula Result =PROPER("zOho sheet") Zoho ...MID
Returns a given number of characters from a text string starting from the a specific given position. Syntax MID(text; start; number) text: The text string to extract the characters from. E.g. "Zoho Sheet" start: The starting point to obtain the ...LOWER
Returns the given text with all characters converted to lowercase. Syntax LOWER(text) text: The text you want to convert to lowercase. E.g. "Zoho Sheet" Examples Formula Result =LOWER("Zoho Sheet") zoho sheet =LOWER(A3) spreadsheet ...LEN
Returns the number of characters (length) in the given text, including spaces. Syntax LEN(text) text: The text that you want to find the length of. E.g. "Zoho Sheet" Remarks The LEN function includes space and non-printable characters in the ...LEFT
Returns the specified number of characters from the beginning of a given text string. Syntax LEFT(text; [number]) text: The text that you want to get the characters from. E.g. "Zoho Sheet" number: Number of characters you want as result. Defaults ...FIXED
Returns a given number with the specified decimal places, formatted as text. Syntax FIXED(number; [decimals]; [omit_separators]) number: The number you want to return as text. E.g. 12534.5 decimals: The number of decimal places to return. ...FIND
Returns the position of a text string (first occurrence) within another given text string. Syntax FIND(find_text; text_to_search; [start_position]) find_text: Text string whose position you want to obtain. E.g. "S" text_to_search: Text to search ...EXACT
Returns TRUE if the two given text strings are identical and FALSE otherwise. Syntax EXACT(text1; text2) text1: The first text string to compare. E.g. "Zoho" text2: The second text string to compare. "zoho" Remarks The EXACT function is ...DOLLAR
Converts the given number to text and applies a currency symbol based on the user's locale settings. Syntax DOLLAR(number; [decimals]) number: The number you want to convert into text, currency format. E.g. 12.5 decimals: The number of decimal ...CONCATENATE
Combines several given text strings into one string. Syntax CONCATENATE(text; [text1]; ...) text: The text or range containing the text strings you want to combine. E.g. "Zoho" Remarks You can use the ampersand symbol (&) instead of the ...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 ...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 ...CHAR
Returns a single text character, given a character code. Syntax CHAR(number) number: The character code, between 1 and 255. E.g. 122 Examples Formula Result =CHAR(37) % =CHAR(101) e =CHAR(65) A Get a hands-on experience of the function in the ...BASE
Returns a text representation of a number in a specified base. For example, base 10 for digits 0-9. Syntax BASE(number; radix; [min_length]) number: The number you want to convert. E.g. 3 radix: The number of unique digits used (ranges from 2 to ...
Access your files securely from anywhere
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Bigin?
New to Zoho Survey?
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
Zoho Creator Resources
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?