How To Use Excel LEFT Function –Explained

Many a time during the on-boarding process, we might be required to take the first few letters from the name to form the login username.

Let’s look at how helpful the Excel’s LEFT function can be to us…!!!

1. What is the LEFT Function?
2. What is the Syntax?
3. How to use it with an example?

1. What is the LEFT Function?

The LEFT function can be used to extract the substring from the supplied text, starting from the leftmost character.


2. What is the Syntax?

=LEFT(text,[num_chars])

  • text  = (Required) Text from which we have to extract the substring or a part of a text.
  • [num_chars] = [Optional] The no.of characters to extract from the left.

Note :

  • [num_chars] is optional and the default value for it is 1.
  • Any formatting applied to the cell (i.e Amount, currency) will not be considered while extracting the substring.

3. How to use it with an example?

Suppose we have to extract the 1st four characters from the name to obtain the USERNAME.

let’s see how to do that…!!!

Excel LEFT Function

**Explained**

=LEFT(C3,4)
  • C3 = Reference to the cell ,from which we want to extract the text from.
  • 4 = The no.of characters to extract from the leftmost side.

 

Hope it has helped you… 

Advertisements

Author: Sharath Raju

Founder@www.ExcelCult.com

Leave a Reply