# How to use the Excel MID function

Uploaded time: 2021-08-30 Difficulty: Primary

### How to use the Excel MID function

### Graphic skills

When using WPS Spreadsheets to process data, sometimes we need to catch part of the data from a series of numbers. We can use the MID formula to realize it, to catch up a certain length of characters from a series of numbers.

In this example, there is a list of phone numbers. The MID function can extract the long series of numbers, keeping the last seven numbers when removing the first three characters. Select cell D2 and click the **Insert Function** to pop up the **Search for a function** dialog. Choose the **MID** formula in the dialog, and click **OK** to insert the MID formula in the target cell. Then, we can see the **Function Arguments** dialog.

There are three arguments in the **MID** formula, **Text**, **Start_num**, and **Num_chars**.

**Start _num** means the cell range for text extraction. In this example, we select B2:B16, which records the data of Phone Numbers.

**Start _num** refers to the beginning position of the first character to be caught. Since we are supposed to extract the last seven numbers for each cell, which counts as 5 characters in total, enter the number 5 in the

**Start_num**input box.

The argument **Num _chars** stands for the length of text contents that we want to extract. In this example, the amount of characters (including the symbol minus -) is eight in total. Therefore, we need to enter the number 8 into the

**Num**

**_**chars**input box. Click**

**OK**to finish.

Place the cursor at the bottom-right corner of cell D2 until the symbol + presents. Drag it to auto-fill the rest of the target cells.

To be office excel advancers, you could learn how to use WPS Office Spreadsheet online in WPS Academy.