Google Sheets Functions: Text

Find the list of all Google Sheets function tutorials on the Functions page.

Text Functions

CONCATENATE	Joins several values together.
JOIN	Joins the values of one or more ranges and allows defining a delimiter.
LEFT	Extracts characters from the left side of a text string.
LOWER	Converts text to lowercase.
MID	Extracts characters from a text string.
PROPER	Converts the first letter of each word to uppercase and the rest to lowercase.
REGEXEXTRACT	Extracts one or more parts of a text using regular expressions.
REGEXMATCH	Checks if a text matches a regular expression.
REGEXREPLACE	Replaces one or more parts of a text using regular expressions.
RIGHT	Extracts characters from the right side of a text string.
SPLIT	Splits a text based on a delimiter and places each fragment into a cell.
SUBSTITUTE	Replaces values with others.
TEXTJOIN	Joins the values of one or more ranges, allows defining a delimiter, and ignores empty values.
TRIM	Removes unnecessary spaces.
UPPER	Converts text to uppercase.