Sheetsdrill

Level 5: Text and dates Exercise 87 of 92

The part before the @

A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.

The task

Return the user name of each email address: everything before the @ sign. Fill B2 and B3 using LEFT and FIND.

What this exercise teaches

FIND returns a position and LEFT cuts by length, so together they split text at a marker wherever it sits. REGEXEXTRACT and SPLIT do the same job; LEFT and FIND also work in every other spreadsheet.

A hint if you get stuck

FIND("@", A2) gives the position of the @. LEFT takes that many characters minus one.

Functions used: FIND, LEFT

Try it now, free, no account needed

Your first 15 exercises on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.

Open this exercise

More exercises in Text and dates