« Home
About
Contact
Archives
Forum
Most Popular
Excel Tips
Charting
Excel Dashboards
Project Mgmt.
Free Downloads
Buy Stuff
Subscribe
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