How to Use the MID Function in WPS on Windows

This how-to guide includes 4 operation topics, all available without membership; use the index below to jump to the task you need.

How-to Index

How-to Guide

1. Enter the MID function

Entry: Formulas tab → formula bar

1. Open WPS Spreadsheet and select the cell where you want to enter the formula.
2. Type = in the formula bar or directly in the cell.
3. Type MID( to start the function.

Success Criteria

• Interface result: The selected cell enters formula input mode.
• Next action available: You can continue entering function arguments.

Tips While Using

• Common mistake: If you do not start with =, the content may be treated as plain text.

2. Review the syntax prompt and fill in arguments

Entry: formula bar

1. After typing MID(, review the syntax prompt shown by the app.
2. Confirm the argument order for text, start position, and character count.
3. Enter the correct arguments for your task.
4. If needed, select cells or ranges directly in the worksheet.

Success Criteria

• Interface result: The formula contains a complete argument structure.
• Next action available: You can press Enter to run the calculation.

Tips While Using

• Common mistake: Unmatched parentheses or missing separators can cause a formula error.

3. Confirm the calculation and check the result

Entry: formula bar

1. Check whether the formula syntax and arguments are correct.
2. Press Enter to confirm the formula.
3. Check whether the result appears in the current cell.

Success Criteria

• Interface result: The cell displays the MID result.
• Next action available: You can edit, copy, or fill the formula further.

Tips While Using

• Common mistake: If the start position or character count is not set correctly, the result may be empty or different from what you expect.

4. Fill the formula down to other cells

Entry: fill handle at the lower-right corner of the result cell

1. Select the cell that already contains the MID result.
2. Move the pointer to the lower-right corner until the + fill handle appears.
3. Drag downward across the target range.
4. Release the mouse to fill the formula into other cells.

Success Criteria

• Interface result: Target cells display corresponding formula results automatically.
• Next action available: You can review each row and adjust references if needed.

Tips While Using

• Common mistake: If references do not change as expected, check whether absolute references are being used.