Top 5 Things to Know in Excel
I remember listing “Microsoft Excel” as a skill on my resume just out of college. The only functions I knew how
Manipulating Text in Excel – LEN, RIGHT, LEFT, & MID
There are many times in Excel when you only need to extrapolate or evaluate PART of a cell. For this, the following functions
RIGHT – Excel Function
What it does: The RIGHT() Function removes a string from the right side of a given piece of text according to parameters you
LEFT – Excel Function
What it does: The LEFT() Function removes a string from the left side of a given piece of text according to parameters you
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