To extract text off the right side of a text string, use the RIGHT function. Use the LEFT method to extract text from the text's left side, and the MID function to retrieve text from the text's middle. The LEN function returns the length of a string as a character count.