text Archives - Excel Nerds

How to Merge Cells in Excel (with Video)

Merging cells in Excel is easy. 99% of the time this is done for formatting improvements. Below we’ll learn how to

There are actually two functions you can use to concatenate data; CONCATENATE and CONCAT. While the CONCATENATE and CONCAT

Videos

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

Videos

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