If we want to get the characters to the left of a character string, we cannot fail to mention the Left function – the function that cuts the left character string, the ** Right** function – the function that cuts the right character string, the

**– the function that takes the middle character string, … Here, Taimienphi will show you how to use the LEFT function through specific examples.**Mid function

### Excel LEFT function, the function cuts the left character string

*How to use the Left function in Excel – Illustrative example*

**Article Table of Contents:1. Benefits of using the LEFT function.2. The LEFT function syntax in EXCEL.3. Specific example using the LEFT function in EXCEL.4. Show how to cut left string with multi-condition LEFT function.5. Common errors when using the LEFT function and how to fix it.**

**1. Benefits of using the LEFT function**

**1. Benefits of using the LEFT function**

+ Used to get the character you want out of the character string.

+ Applicable to multiple data series

*2. LEFT function syntax in EXCEL*

*2. LEFT function syntax in EXCEL*

*Syntax*: **=LEFT(text, n)***Where*: – text: Sign string

– n: The number of characters to be cut from the string. (Without this parameter, Excel defaults to a value of 1.)*Function*: Cut out n characters in the text string from the left side of the string.

*3. Specific examples using the LEFT function in EXCEL*

*3. Specific examples using the LEFT function in EXCEL*

**Example 1:**

To cut a character to the left of the string, use the LEFT function.

Here to get the first character of the employee code with the formula : **E5=LEFT(C5)**

**Example 2:** We have the following data table:

This data sheet requires you to retrieve all the characters of the employee code.

You will use the **LEFT** formula and get out the 3 characters on the left hand side

Formula :** E5=LEFT(C5,3)**

So you have obtained the alphanumeric code through the employee code, you just need to click on the code field and scroll down to get the result of the entire employee code.

Often users use the LEFT function to get the left characters in Excel data, that‘s why the definition of the function to get 4 characters on the left was born, if you have any problems or questions about how to use the function ** to get 4 characters on the left** , please remember the LEFT function immediately.

**4. Show how to cut left string with multi-condition LEFT function.**

**4. Show how to cut left string with multi-condition LEFT function.**

**4.1. Combine the VALUE function and the LEFT function to get the left numeric character of the data.**

**Step 1:** Enter the formula: **Value(Left(Text,Numcharts))**.

With: **+ Text** is the cell you want to get the data from**+ Numcharts** is the number of characters you want to get

**Step 2:** Press **Enter** and drag down to the lower lines for the data to be entered.

**4.2. Combine LEFT function and LEN function to cut the left character string**

**Step 1: ** Select any cell to enter the **formula =Left(Text,Len(Text)-2)).**

**Where:**

**Text: **is the data cell you want to cut.**-2:** is the number of characters you want to cut.

**Step 2:** Press **Enter** and drag down the other lines for the data to be entered. The result will be as shown below.

**4.3. Combine the Left function and the Search function to find and cut the left character string.**

**Step 1: ** Select any cell to enter the **formula =Left(Text,Search(” “,Text))**.

**Where:**

**Text:** is the data cell you want to cut.

” **“:** is the character where you want to get the data on its left side (here is the space)

**Note:** Here we combine 2 functions so at the end of the formula there must be 2 brackets.

**Step 2:** Press **Enter and finish** (hold down the small square and scroll down if you have a lot of data!!)

**5. Common errors when using the LEFT function and how to fix it**

**5. Common errors when using the LEFT function and how to fix it**

If your data cell has a text error that creates spaces as in the **Student names** section of the following data table, you can apply the **LEFT** function formula that combines **the TRIM** and **LEN** functions.

-Result:

– The number of **num-chars characters is less than 0**. If you are **combining the Left** function with **1 combination of other functions such as Len or Search** , the LEFT function will return the error value** #VALUE!**, now check the function combination **again** .

– The source value is **the date** that will be **changed to a number**.

– How to fix wrong date data when using **the Left function** using the **Text(Value,”mmmm d/yyyy”)**.

**Where:**

**K5:** Value is the data to be converted**“d mmmm,yyy”:** is a date format converted to Text.

We have introduced the syntax and usage of the Left function, the function cuts the left character string on the spreadsheet through illustrations, in excel there are many other useful functions to help you manipulate the spreadsheet effectively.

https://thuthuat.taimienphi.vn/ham-left-trong-excel-1301n.aspx

The SUM sum calculation function is also a commonly used function in Excel, knowing how to use the SUM function will help you calculate in Excel worksheet more flexible.