How to Use the MID Function in WPS on Windows

Last updated:July 23, 2026

Use MID with 3 how-to topics, all available without membership; choose a task from the How-to Index and follow the steps to set up and verify the formula.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and enter MIDFree
22. Set the MID parameter formatFree
33. Review and reuse results in recordsFree

How-to Guide

1. Create a formula field and enter MID

Entry path: Add Field → Formula

  1. Open the multi-dimensional table you want to edit.
  2. Click Add Field.
  3. Select Formula as the field type.
  4. Enter a formula that includes MID in the formula editor.
  5. Click Confirm to save the field.

Success Criteria

  • Interface result: A new formula field appears in the table.
  • What you can do next: You can continue editing parameters and review the calculated result.

Tips While Using

  • Common mistake: If you do not choose the Formula field type, you cannot enter a function formula.
  • Environment note: You need permission to edit fields in the current multi-dimensional table.

2. Set the MID parameter format

Entry path: Formula Editor → Function Library → MID

  1. Select the MID function in the formula editor, or type MID(...) manually.
  2. Fill in the parameters in the required function format.
  3. Set the first parameter as the target text or field reference.
  4. Set the second parameter as the start position.
  5. Set the third parameter as the extraction length.
  6. Check the parentheses, commas, and references, then save the formula.

Success Criteria

  • Interface result: The formula editor shows a complete MID formula.
  • What you can do next: After saving, you can review the returned result in records or continue editing.

Tips While Using

  • Common mistake: If the parameter order is wrong, the returned result may not match your expectation.
  • Environment note: The referenced field content should match the text extraction scenario.

3. Review and reuse results in records

Entry path: Formula field result column → Record area

  1. After saving the formula, review the formula field result in the current record.
  2. Check whether the returned content matches the expected extraction position.
  3. If needed, return to the formula editor and adjust the start position or length.
  4. After adding or importing records, continue checking whether the formula field refreshes automatically.

Success Criteria

  • Interface result: Each record shows its corresponding extracted result in the formula field.
  • What you can do next: After new data is added, the result updates with the record content.

Tips While Using

  • Common mistake: If the source field content is too short, the result may return only the remaining characters.
  • Environment note: If the source field is empty or the format does not match, check the original data first.