Explanation
Extra spaces can cause problems in filtering, matching, and reporting.
The TRIM function removes unnecessary spaces.
Example
|
Original |
Formula |
Result |
|
Amit |
=TRIM(A2) |
Amit |
|
Neha Sharma |
=TRIM(A3) |
Neha Sharma |
Standardizing Case
Use:
- UPPER() → uppercase
- LOWER() → lowercase
- PROPER() → proper case
Example
=PROPER(TRIM(A2))
Converts:
rahul singh
to:
Rahul Singh
Practice
Clean customer names and city names using:
TRIM + PROPER