How to Remove Text from a Cell in Excel
One of the most frustrating problems in Excel is when you want to remove text from a cell. The SUBSTITUTE function is
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: