Home › Learn Excel › Lesson 11
Take parts out of text: the first or last characters, a piece from the middle, or everything before a symbol.
LEFT takes a number of characters from the start of a text. The order codes begin with a two-letter country code. Take the country code (the first two characters) from the order code, in B2LEN counts every character in a text, including spaces and dashes. Count the characters in the product code, in B2FIND returns the position of a character in a text, counting from the left. Find the position of the @ in the email address, in B2TEXTBEFORE returns everything before a character you choose. TEXTAFTER returns what comes after it. Take the part of the email address before the @, in B2