Excel Left Formula

Learn How to use Excel Left Formula:

Excel Left Formula extracts the specified number of characters from the left hand side of a cell. It is used to remove unwanted characters from Right Side of a cell.

Left Function Syntax: Left(text, [num_chars])

Text: It is the cell or text string having the data to extract.
Num_Chars: Optional. It specifies number of characters to extract.

Example on Excel Left Formula:

In below data, Production Code, Manufacturing Year and Manufacturing Location is mentioned in Column B. We need to extract Production Code that is at the right hand side of the Cell. All production codes are in 3 characters.

Excel Left Formula

Example: Left Formula

Excel Left Formula is used in Cell C2 (Highlighted with Yellow color) to extract Production Code. Text is Cell B2 having the data to extract. Production Code has been mentioned in 3 characters. So number of characters to return is 3. Cell C2 has returned A52 which is the Manufacturing Location code of Row No.2.

The Same formula is copied down to all other cells where Production Code is required.

Hope you may find this useful.

You may also consider learning Right Function and Mid Function.

 


Categories: Formulas

Tags: ,

Leave a Reply

%d bloggers like this: