Excel Functions: Text
Find the list of all Excel function tutorials on the page Excel Functions.
Text Functions
LEFT | Extracts characters from the left. |
LOWER | Converts to lowercase. |
MID | Extracts characters from a string. |
PROPER | Converts the first letter of each word to uppercase and the other letters to lowercase. |
RIGHT | Extracts characters from the right. |
SUBSTITUTE | Replaces textual values with others. |
TEXTJOIN | Assembles the values of one or several ranges of data using the defined separator. |
TEXTSPLIT | Splits a text using column and row separators. |
TRIM | Removes unnecessary spaces from the text. |
UPPER | Converts to uppercase. |