Excel LEFT() Function

The LEFT () function in excel returns the leftmost characters from a text value. This function is used for data manipulation.

Syntax

LEFT(Text, [num_chars])

Parameter

Text (required)- This parameter represents the string from which you want to find letters.

num_chars(optional)- This parameter represents the number of characters you want to read from the left.

Category

Text

Return

This function returns the number of specified characters from the start of the string.

Example 1

Objective: Use the LEFT function on the following strings

Text Result Formula
Beautiful World Beaut  =LEFT(A19,5)
EXCEL IS WOW EXCEL IS  =LEFT(A20,8)
Welcome to Excel ; Welcome to Exce  =LEFT(A21,15)
876 8  =LEFT(A22,1)
SUPERSTORE IS opened; SUPERSTORE IS  =LEFT(A23,LEN(A23)-7)

Example 2

Objective: Extract FirstName using functions left function

Name First Name Formula Used
Sukla Pati Sukla P =LEFT(B7,7)
Rachel Buffay Rachel =LEFT(B8,7)
Joey Mitchell Joey Mi =LEFT(B9,7)
Chandler Kumar Patra Chandle =LEFT(B8,7)
Delia Azahari Delia A =LEFT(B9,7)
Mar Martin Castellano Mar Mar =LEFT(B10,7)
Daniel Oso Daniel =LEFT(B11,7)

Example 3

Objective: Use the LEFT function to get the results in the 2nd column

Text Result Formula
Phone Number is +(0)1234 Phone Number is +(  =LEFT(A19,18)
This is used for data cleaning This is used for data cle  =LEFT(A19,25)



ADVERTISEMENT
ADVERTISEMENT