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… 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: