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,
CHAR – Excel Function
What it does: The CHAR() returns the character specified by a number. Plain English: When you see CHAR(), think