Excel Functions: Text

Find the list of all Excel function tutorials on the page Excel Functions.

Text Functions

LEFTExtracts characters from the left.
LOWERConverts to lowercase.
MIDExtracts characters from a string.
PROPERConverts the first letter of each word to uppercase and the other letters to lowercase.
REGEXEXTRACTExtracts text values based on a regular expression.
REGEXREPLACEReplaces text values based on a regular expression.
REGEXTESTChecks whether a string matches a regular expression.
RIGHTExtracts characters from the right.
SUBSTITUTEReplaces textual values with others.
TEXTJOINAssembles the values of one or several ranges of data using the defined separator.
TEXTSPLITSplits a text using column and row separators.
TRIMRemoves unnecessary spaces from the text.
UPPERConverts to uppercase.