Formuladrill

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

Often used together with: LOWER

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