How to Use the LEFT Function in WPS on Windows

Last updated:July 20, 2026

Use LEFT through 1 task in the index below to extract characters from the left side of text; 1 item is available without membership and 0 items are membership-related.

How-to Index

#TopicMembership
11. Use the LEFT functionFree

How-to Guide

1. Use the LEFT function

Entry point: Formulas tab → formula bar

  1. Open AirSheet and select the cell where you want to enter the formula.
  2. Type = in the formula bar or directly in the cell to start the formula.
  3. Type LEFT( and review the syntax guidance that appears automatically.
  4. Enter the required arguments based on the prompt, then press Enter.
  5. Confirm that the calculation result appears in the current cell.

Success Criteria

  • UI state: The cell displays the result returned by the LEFT formula.
  • Next actions: You can continue copying the formula, editing arguments, or filling it down.

Tips While Using

  • Common mistakes: Missing parentheses, incorrect argument separators, or forgetting to start with =.
  • Environment limits: If the referenced source cell changes, the result updates automatically.