This function displays a specified number of characters from the left hand side of a piece of text.
Syntax
=LEFT(OriginalText,NumberOfCharactersRequired)
No special formatting is needed.
| Argument | Description |
| text | The text string from which you want to extract characters. |
| num_chars | Optional. Specifies the number of characters to extract from the left side. |
Note: If you omit num_chars, Excel considers it as 1.
| (Text) | (Formula) | (Result) |
| EXCEL2026 | =LEFT(A2,3) | EXC |
| COMPUTER | =LEFT(A3,4) | COMP |
| PYTHON | =LEFT(A4,2) | PY |
| PYTHON | =LEFT(A5) | P |
| LEFT is a Text Function in Excel. |
| It is used to extract characters from the left side of a text string |
| 1 is the default number of character |
| num_chars argument should be a positive number |
If we use num_chars greater than text length, it will return complete text. A6 cell has value MOUSE, we use below formula.=LEFT(A6,100) output will be MOUSE |
| It works on text, numbers & cell references. |
