Text functions in Canva Sheets
Text functions help manipulate, format, and analyse text data. These are useful for combining text, extracting specific characters, and converting cases.
Text functions
Text functions help manipulate, format, and analyse text data. These are useful for combining text, extracting specific characters, and converting cases.
FUNCTION | WHAT IT DOES | EXAMPLE |
|---|---|---|
TEXT | Converts a value to text with a specific format. | =TEXT(12345, "00000") → 12345 |
VALUE | Converts a text string into a number. | =VALUE("100") → 100 |
CONCAT | Combines text from multiple ranges and/or strings. | =CONCAT(A1:A3) |
CONCATENATE | Joins multiple text values into one (older function, doesn’t support ranges). | =CONCATENATE(A1, " ", B1) |
LEN | Counts the number of characters in a string, including spaces. | =LEN("Hello World") → 11 |
LEFT | Extracts a specified number of characters from the start of a string. | =LEFT("Canva", 3) → Can |
RIGHT | Extracts a specified number of characters from the end of a string. | =RIGHT("Canva", 2) → va |
UPPER | Converts text to uppercase. | =UPPER("hello") → HELLO |
LOWER | Converts text to lowercase. | =LOWER("HELLO") → hello |
CHAR | Returns the character for a given code number. | =CHAR(number) |
CLEAN | Removes non-printable characters from text. | =CLEAN(text) |
CODE | Returns the numeric code for the first character in text. | =CODE(text) |
EXACT | Checks if two text strings are identical. | =EXACT(text1, text2) |
FIND | Finds text within text (case-sensitive). | =FIND(find_text, within_text, [start_num]) |
FIXED | Formats a number as text with a fixed number of decimals. | =FIXED(number, [decimals], [no_commas]) |
MID | Extracts characters from the middle of text. | =MID(text, start_num, num_chars) |
PROPER | Capitalises the first letter of each word. | =PROPER(text) |
REPT | Repeats text a specified number of times. | =REPT(text, number_times) |
SEARCH | Finds text within text (case-insensitive). | =SEARCH(find_text, within_text, [start_num]) |
SUBSTITUTE | Replaces text with new text. | =SUBSTITUTE(text, old_text, new_text, [instance_num]) |
T | Returns the text if the value is text. | =T(value) |
TEXTAFTER | Returns the text after a delimiter. | =TEXTAFTER(text, delimiter, [instance_num]) |
TEXTBEFORE | Returns the text before a delimiter. | =TEXTBEFORE(text, delimiter, [instance_num]) |
TEXTJOIN | Joins text with a delimiter. | =TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...) |
TRIM | Removes extra spaces from text. | =TRIM(text) |
UNICHAR | Returns the Unicode character for a given number. | =UNICHAR(number) |
UNICODE | Returns the Unicode number for the first character in text. | =UNICODE(text) |
VALUETOTEXT | Converts a value to text. | =VALUETOTEXT(value, [format]) |
Was this helpful?
Helpful
Unhelpful