TEXT formulas

(Text Functions)

Excel does not only perform financial calculations. There are several text functions which come in useful in the workplace and can save endless time.

CONCAT / CONCATENATE	Joins a list or range of text strings (joins two or more cells together)
UPPER	Converts the text to uppercase
LOWER	Converts the text to lower case
PROPER	Converts the text to proper case. The first letter in each word to uppercase and the other letters to lower case
LEFT	Returns the specified number of characters from the start of a text string
MID	Returns the characters from the middle of a text string, given a starting position and length
RIGHT	Returns the specified number of characters from the end of a text string