Free LEFT Formula Generator

Returns the first character or characters in a text string, based on the number of characters you specify.

Generated Formula
=LEFT(text, 1)

Learning Resources

Want to master Excel? Check out this Top-Rated Course.

Want to become an Excel Pro?

Stop searching for formulas. Master Excel in 30 days with this top-rated course.

Learn More