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
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:
Using SUBSTITUTE and CHAR to remove a block of unwanted text
The SUBSTITUTE function is incredible for cleaning up text. You can replace a string of text with whatever you’d like,