FIND

Learn how LEN, FIND, LEFT, RIGHT, MID and TRIM clean and split text, why FIND and SEARCH differ, and which spaces TRIM cannot remove.