text Archives - Excel Nerds

How to Merge Cells in Excel

One of the easiest formatting improvements you can make is to merge cells in Excel. This is very commonly done when creating

Here’s a quick intro the functions LEFT, RIGHT, and MID. These are very important if parsing data from larger strings

If cleaning up messy data is part of your work flow, the substitute function is sure to come in helpful. Learn how to use it here:

Excel

I remember listing “Microsoft Excel” as a skill on my resume just out of college. The only functions I knew how

Excel

There are many times in Excel when you only need to extrapolate or evaluate PART of a cell. For this, the following functions

What it does: The RIGHT() Function removes a string from the right side of a given piece of text according to parameters you

What it does: The LEFT() Function removes a string from the left side of a given piece of text according to parameters you

What it does: The MID() Function returns a specific part of a larger text string, subject to the arguments you provide. Plain

What it does: The CHAR() returns the character specified by a number. Plain English: When you see CHAR(), think