Use the LENB function in WPS with 3 how-to topics, all available without membership, so you can choose a topic from the index and complete it step by step.
How-to Index
| No. | Topic | Membership |
|---|---|---|
| 1 | 1. Insert LENB from the Insert Function dialog | Free |
| 2 | 2. Type the LENB formula directly in a cell | Free |
| 3 | 3. Check LENB syntax and parameter details | Free |
How-to Guide
1. Insert LENB from the Insert Function dialog
Entry: Formulas tab → Insert Function
- Select the cell where you want to enter the formula.
- Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
- Search for LENB in the dialog box.
- Select the function and click OK.
- Enter the required arguments in the parameter dialog.
- Click OK to insert the function.
Success Criteria
- The target cell contains the LENB function.
- You can continue editing the arguments or confirm the result.
Tips While Using
- If the function name is typed incorrectly in search, it may not appear in the results.
- Internet access is needed if you open the help link from the dialog.
2. Type the LENB formula directly in a cell
Entry: Worksheet cell → Formula bar
- Select the target cell.
- Type
=LENB(...)directly in the cell or in the formula bar. - Press Enter to confirm.
- If you want to review the syntax, type
=LENB(and press F1 to open the related prompt or help entry.
Success Criteria
- The cell shows a calculated result.
- The formula bar keeps the LENB formula for further editing.
Tips While Using
- Incorrect separators or incomplete arguments can cause formula errors.
- Check cell references carefully before filling the formula to other rows.
3. Check LENB syntax and parameter details
Entry: Formulas tab → Insert Function
- Click Insert Function on the Formulas tab.
- Search for LENB.
- Select the function to review its syntax and parameter area.
- Click the related help link to open more details.
Success Criteria
- You can see the LENB name, syntax, and parameter guidance.
- You can return to the worksheet and continue editing the formula.
Tips While Using
- The parameter panel may not update until the function is selected.
- Internet access is needed for online help content.