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
28
Apr
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,
31
Dec