How to get Left characters from cells in Excel | How to use LEFT function (formula) in Excel

LEFT

Use of LEFT Formula / Function in Excel

LEFT Formula/Function helps to return left characters in particular
cell in to another cell.
It begin at left position.

Syntax/Formula of LEFT function in Excel

The syntax of LEFT formula in Microsoft Excel is below.

=LEFT(text,[num-chars])

Example of LEFT Function in Excel

Step 1: First type ADVANCEDMSEXCEL.BLOSPOT.COM in cell B4 as per shown in below image.

Step 2: Type formula =LEFT(B4,8) in cell B6 and press enter.

LEFT FUNCTION