Google Sheets Functions: Text

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

Text Functions

CONCATENATEJoins several values together.
JOINJoins the values of one or more ranges and allows defining a delimiter.
LEFTExtracts characters from the left side of a text string.
LOWERConverts text to lowercase.
MIDExtracts characters from a text string.
PROPERConverts the first letter of each word to uppercase and the rest to lowercase.
REGEXEXTRACTExtracts one or more parts of a text using regular expressions.
REGEXMATCHChecks if a text matches a regular expression.
REGEXREPLACEReplaces one or more parts of a text using regular expressions.
RIGHTExtracts characters from the right side of a text string.
SPLITSplits a text based on a delimiter and places each fragment into a cell.
SUBSTITUTEReplaces values with others.
TEXTJOINJoins the values of one or more ranges, allows defining a delimiter, and ignores empty values.
TRIMRemoves unnecessary spaces.
UPPERConverts text to uppercase.