Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Learn Excel › Lesson 11

LEFT, RIGHT, MID and FIND in Excel

Take parts out of text: the first or last characters, a piece from the middle, or everything before a symbol.

  1. The first characters: LEFT. 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 B2
  2. How long: LEN. LEN counts every character in a text, including spaces and dashes. Count the characters in the product code, in B2
  3. Where is it: FIND. FIND returns the position of a character in a text, counting from the left. Find the position of the @ in the email address, in B2
  4. FIND or SEARCH?.
  5. Your turn: TEXTBEFORE. TEXTBEFORE returns everything before a character you choose. TEXTAFTER returns what comes after it. Take the part of the email address before the @, in B2

← All lessons