Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
How to use the MID function in WPS Spreadsheet
Uploaded time: August 30, 2021 Difficulty Intermediate
How to use the MID function in WPS Spreadsheet
How to use the MID function in WPS Spreadsheet
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 theFunction 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_charsinput 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.
Also Read:
- 1. The AND Function in WPS Spreadsheet
- 2. How to use the Spell Check function in WPS Spreadsheet
- 3. How to use the Trace Dependents function in WPS Spreadsheet
- 4. The Word Typesetting function in WPS Writer
- 5. How to use the Quick Parts function in WPS Writer
- 6. How to use the formula function of table in WPS Writer
Does this video help you?