MID – Excel Function
What it does: The MID() Function returns a specific part of a larger text string, subject to the arguments you provide. Plain
CHAR – Excel Function
What it does: The CHAR() returns the character specified by a number. Plain English: When you see CHAR(), think
UPPER – Excel Function
What it does: The UPPER() Function converts text to lowercase. Plain English: Simple. This function converts text to be all
LOWER – Excel Function
What it does: The LOWER() Function converts text to lowercase. Plain English: Simple. This function converts text to be all
LEN – Excel Function
What it does: The LEN() function returns the length (number of characters) of a given text or string. Plain English: This
CONCATENATE – Excel Function
What it does: The CONCATENATE() Function combines two or more strings together. Plain English: This is one of the simplest
TRIM – Excel Function
What it does: The TRIM() function removes extra spaces from a text string, whether at the beginning, middle, or end. It will