LEFT, RIGHT, MID & FIND practice exercises

LEFT, RIGHT and MID pull characters out of text by position. FIND tells you where a character (like a space or @) is, so you can cut text at the right place even when the lengths differ.

Syntax

LEFT(text, n)  ·  RIGHT(text, n)  ·  MID(text, start, n)  ·  FIND(search, text)  ·  LEN(text)
LEFT / RIGHT
The first or last n characters.
MID(text, start, n)
n characters starting at position start (the first character is 1).
FIND(search, text)
The position of search inside text. Case-sensitive; SEARCH is the case-insensitive version.

The practice data

Customer records with full names, emails, product codes (country-number-color) and messy city names. Every exercise below uses this sheet, and your answer goes in H2.

ABCD
1Full nameEmailProduct codeCity
2Ana Lopez[email protected]US-4417-RED new york
3Ben Ortiz[email protected]CA-0932-BLUTORONTO
4Cara Smith[email protected]US-1205-GRNchicago
5Dev Patel[email protected]UK-7781-BLKLondon
6Eva Ross[email protected]US-3390-REDsan diego

Worked example

=LEFT(C2,2)

The first 2 characters of the product code: the country. Result:

US

Your turn: 3 exercises

Type a formula and press Enter. It is checked by a real formula engine, so any correct approach counts.

1 Return the 4-digit number from the product code in C3.

H2

2 Return the color code (last 3 characters) of the product code in C4.

H2

3 Return the first name from A5, using FIND to locate the space.

H2

Master LEFT, RIGHT, MID & FIND in the full course

Lesson 7 of 18 goes deeper, with more exercises in a real spreadsheet grid. Start with the first 4 lessons free, then unlock everything with Pro.

Start free See pricing

Common LEFT, RIGHT, MID & FIND mistakes

FAQ

How do I get the last name?

=MID(A2,FIND(" ",A2)+1,LEN(A2)) returns everything after the first space.

Is there an easier way to split text?

Yes: SPLIT in Google Sheets (TEXTSPLIT in Excel 365). See the SPLIT exercises.

Keep practicing