Excel - The LEFT function

April 2018


[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".
Published by deri58. Latest update on November 21, 2011 at 12:11 PM by deri58.
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 (https://ccm.net/).
Excel - Extract string of characters
Excel - The ATAN function