Left Excel Formula




Excel Formulas > Text Functions > LEFT

« Find | Left | Len »

What is the use of Left formula?

Cuts a text from left


Syntax of Left formula:
left(from this text, this many letters)

Examples of Excel Left formula:
left("Pointy Haired Dilbert rocks", 6) = Pointy
left(A1,5) = first five characters in the cell A1

Buy Excel Formula E-book | Learn more about Excel Left Formula

More Text Functions : Concatenate | Find | Left | Len | Lower | Mid | Proper | Rept | Substitute | Trim | Upper | Value

Mathematical Functions | Text Functions | Logical & Reference Functions
Date & Time Functions | Financial Functions | Information Functions

Microsoft Excel Formula Training - Ebook