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
06
Oct
How to Use CONCATENATE in Microsoft Excel
There are actually two functions you can use to concatenate data; CONCATENATE and CONCAT. While the CONCATENATE and CONCAT
01
Sep
Learn the LEFT, RIGHT, and MID Functions in Excel
Here’s a quick intro the functions LEFT, RIGHT, and MID. These are very important if parsing data from larger strings
How to use the Substitute Function (Video)
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:
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
06
Oct
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
27
Sep
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