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.
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.