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 |