Excel FunctionsLesson 116Free preview
TRIM
This lesson is part of Excel · All levels
Summary
TRIM is an Excel text function that removes excess space at the beginning and end of the text, while converting the middle space array into one space. The syntax is. This function is important to clean up the copy-paste data before matching.
Key points
- Delete spaces at the beginning and end of text
- Repair the gap in the middle of the grid into one space
- It doesn't remove a single space that separates the word
- Often combined with VLOOKUP to match the search key
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.