LEFT practice
LEFT returns the first characters of a text. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.
Syntax
LEFT(text, [number_of_characters])
What people get wrong
Combine with FIND to take everything before a separator.
Google Sheets exercise that use LEFT
- The part before the @Level 5
Practice LEFT now
Your first 15 exercises are free without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free