Use the LEFT function with 3 how-to topics, all available without membership; start from the How-to Index, then follow the entry path and steps for each task.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Enter LEFT from the Insert Function dialog box | Free |
| 2 | 2. Type the LEFT formula directly in a cell | Free |
| 3 | 3. Review LEFT syntax and argument details | Free |
How-to Guide
1. Enter LEFT from the Insert Function dialog box
Entry path: 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 LEFT in the dialog box.
- Select the function and click OK.
- Enter the text argument and the number-of-characters argument in the function arguments dialog box.
- Click OK to finish entering the function.
Success Criteria
- On-screen result: The target cell shows the result returned by LEFT.
- What you can do next: You can continue editing arguments, copy the formula, or fill it down.
Tips While Using
- Common mistake: If the function name or argument order is incorrect, the result may not match what you expect.
- Environment note: An internet connection is needed if you open online help links.
2. Type the LEFT formula directly in a cell
Entry path: Cell → Formula bar
- Select the cell where you want to enter the formula.
- Type
=LEFT(...)directly in the cell or in the formula bar. - Press Enter to confirm.
- If you want to apply it to more cells, drag the fill handle to copy the formula.
Success Criteria
- On-screen result: After you press Enter, the cell returns the extracted text.
- What you can do next: You can adjust references or copy the formula to other cells.
Tips While Using
- Common mistake: If separators or parentheses are incomplete, the formula will not calculate correctly.
- Environment note: When copying formulas in bulk, check relative and absolute references.
3. Review LEFT syntax and argument details
Entry path: Formulas tab → Insert Function
- Click Insert Function on the Formulas tab.
- Type LEFT in the search box.
- Select the function to review its syntax and argument details.
- Confirm how the text argument and character-count argument should be entered.
- Open the related help page if you need more explanation.
Success Criteria
- On-screen result: You can see the LEFT function name, syntax structure, and argument details.
- What you can do next: You can move directly to argument entry and complete the formula.
Tips While Using
- Common mistake: Checking only the function name without reviewing the argument meaning can lead to incorrect extraction results.
- Environment note: Opening an external help page requires an internet connection.