How to Clean Large Text Strings (LEN, CHAR, CONCATENATE, and more)
Following up on our post about some of the most commonly used text functions, today we’re going to focus on cleaning up
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,
SUBSTITUTE – Excel Function
What it Does: The SUBSTITUTE() function in Excel substitutes one or more instances of a string (or number) for something