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
Following up on our post about some of the most commonly used text functions, today we’re going to focus on cleaning up
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:
The SUBSTITUTE function is incredible for cleaning up text. You can replace a string of text with whatever you’d like,
What it Does: The SUBSTITUTE() function in Excel substitutes one or more instances of a string (or number) for something