The LEFT function returns a sub-string from a specified string, starting from the left-most character. In this guide, we’re going to show you how to use the Excel LEFT function and also go over some tips and error handling methods.
- All Excel versions
Excel LEFT Syntax
|text||The text that contains the sub-string you want to extract.|
|[num_chars]||Optional. The number of characters you want to extract.|