## What is the MID function in Excel?

The **MID **function is one of the (**TEXT**) functions of Excel. It returns the characters from the

middle of a text string, given a starting position and length.

We can find this function in **TEXT** of insert function Tab.

## How to use **MID **function in excel

- Click on empty cell (like F5 )

2. Click on **fx** on the below of font word (or press** shift+F3**)

3. In insert function tab you will see all functions

4. Select **TEXT **category

5. Select **MID **function

6. Then select **ok**

7. In function arguments Tab you will see **MID **function

8. **Text** is the text string from which you want to extract the characters

9. **Start_ num** is the position of the first character you want to extract. The first character in Text is 1

10. **Num_chars** specifies how many characters to return from Text

11. You will see the **results **in formula result section

## Examples of MID function in Excel

**How do I extract a middle and last name in Excel?**

## What is the purpose of MID function?

It returns the characters from the middle of a text string, given a starting position and length.

## What is the Return value of MID function?

It can return any type of data.The following formula is used for MID value:

`MID (`**text**,**Start_ num**,**Num_chars**)=number,text,...

## How many arguments does MID function have?

MID (**text**,**Start_ num**,**Num_chars**)

**REPLACE** function has 3 argument.

**Text** is the text string that contains the characters you want to extract.

** Start_ num **is the position of the first character you want to extract. The first character is1.

** Num_chars **specifies how many characters to return from Text.

**New text** is the text that will replace characters in Old text.

## Which version of excel supports MID function?

This function is available for all excel **versions **(2003-2019)

## Errors in MID function

This function has NO error.

## What questions does the MID function answer?

**Is mid a text function? **

**What is middle in Excel? **

**How do I extract middle text in Excel?**

**Why is mid used?**

**Is Mid and Substr same?**

**How do you use left right and mid in Excel?**

**How do I extract part of a cell in Excel?**

**How do you extract data from the middle of a cell?**

**What is the difference between left right and mid function?**

**How do I pull middle characters in Excel?**

**How do I extract only some data from a cell in Excel?**