Excel Data Cleanup (TRIM, CONCATENATE, LEN, RIGHT, LEFT, MID)

TRIM =TRIM(text) Removes all space from a text string except for single spaces between words
CONCATENATE =CONCATENATE(text1, [text2], …) Joins several text strings into one text string
LEN =LEN(text) Returns the number of characters in a text string
RIGHT =RIGHT(text, [num_chars]) Returns the specified number of characters from the end of a text string
LEFT =LEFT(text, [num_chars]) Returns the specified number of characters from the start of a text string
MID =MID(text, start_num, num_chars) Returns the characters from the middle of a text string, given a starting position and length