LEFT practice
LEFT returns the first characters of a text. Below are the 1 Excel exercise on Formuladrill 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.
Excel exercise that use LEFT
- Build an email addressLevel 4Pro
Practice LEFT now
The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free