LEFT, RIGHT & MID Functions in Microsoft Excel

Brief Introduction

            Microsoft Excel Left, Right & Mid functions are text functions, so these Text functions are useful to extract a required part of the text from a cell.

Purpose:

Extract a specific part of a text from a cell.

Syntax of Left, Right & Mid Functions:

The syntax of Left, Right & Mid Functions in Excel are as follows;

• =LEFT(text, [num_chars])

• =RIGHT(text, [num_chars])

• =MID(text, start_num, num_chars)

Return value:

A required part of text.

Arguments: 

• Criteria - The criteria (Condition) used to determine that from which cells to extract part of the text.

You can download free the Complete Practice of Concern Topic of Microsoft Excel File, Click on the below download icon,

  

          

              This article explains in simple terms how to use LEFT, RIGHT & MID Functions. It takes a step-by-step approach, & following below contents we will touch in this post.

1. LEFT Function explanation through example.
2. RIGHT Function explanation through example.
3. MID Function explanation through example.

Let’s start to learn something new about the LEFT, RIGHT & MID Functions of Microsoft Excel.                

1.  LEFT Function.

             LEFT Function in Microsoft Excel is a text function, so it is used to extract a specific left portion of text from the reference of cell information, as we explain this function through a given below example,

Explanation: - The LEFT function is very simple to use because we need only 2 pieces of information, the initial text (generally the reference of a cell) and second the number of digits we want to extract, in the above example the initial text in cell "C4" is "Washing Machine" & the second thing is the number of digit we want to extract from cell "C4" is "5" (It means first or left side 5 digits we need to know about them), so as shown in the example the LEFT Function extract our required parts of text 5 digits "Washi".            

In this scenario, we have used a formula like below,

=LEFT(C4,5)

2.  RIGHT Function.

            RIGHT Function in Microsoft Excel is also a text function & it is used to extract specific right portion of text from the reference of cell information, as we explain this function through a given below example,

Explanation: - The RIGHT function is very simple to use because we need only 2 pieces of information, the initial text (generally the reference of a cell) and second the number of digits we want to extract, in the above example the initial text in cell "C7" is "Microwave Oven" & the second thing is the number of digits we want to extract from cell "C7" is "7" (It means last or right side 7 digits we need to know about them), so as shown in the example the RIGHT Function extracts our required parts of text 7 digits "ve Oven".   

In this scenario, we have used a formula like below,

=RIGHT(C7,7)

Note: - The above result "ve Oven" have 6 digits & one space, as the space in reference cell of information also consider a digit.

3.  MID Function.

             MID Function in Microsoft Excel is also, a text function & it is used to extract specific mid-portion of text from the reference of cell information, as we explain this function through a given below example,

Explanation: - The MID function is very simple to use because we need only 3 pieces of information, the initial text (generally the reference of a cell), second the Number of digits we want to start from it & last one the number of digit we want to extract, in the above example the initial text in cell "B5" is "BCA5315", the second thing is the number of digits we want to start from it is "3" or "A" & the last thing is the number of digit we want to extract from cell "B5" is "5" (It means mid side 5 digits we need to know about them), so as shown in example the MID Function extract our required parts of text 5 digit "A5315".  

In this scenario, we have used a formula like below,

=MID(B5,3,5)