Excel - The LEFT function
[Excel] The LEFT function
This function allows you to retrieve a sub-string (set of characters) from a string. Beginning from the left hand side.
LEFT( cell/text, num_of_characters )
- Consider A2 contains "ccm".
- Then
=Left(A2, 5)
- Will return "kiosk".
Related
- Excel - The LEFT function
- Excel vba search function - Guide
- Excel - The SEARCH function - How-To - Excel
- Excel - The LEN function - How-To - Excel
- Excel - The MAX function - How-To - Excel
- Excel - The NOW function - How-To - Excel
This document, titled « Excel - The LEFT function », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).