Members lesson 26
Clean text
Remove extra spaces, fix name case, and extract useful parts of text.
What you will practice
- Clean spacing and capitalization
- Extract text from the left, right, or middle
- Measure cleaned text with LEN
Lesson preview
Starting tableImported text
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Raw value | Task | Clean result | |
| 2 | ana chen | Remove extra spaces | ||
| 3 | mARCO rUIZ | Fix name case | ||
| 4 | INV-2048-WEST | Prefix | ||
| 5 | Region | |||
| 6 | Number | |||
| 7 | support@example.com | Clean length |