Clean up spaces with the TRIM function

- [Narrator] In this worksheet called HR List Spaces…in our chapter 10 exercise file.…We've got a problem in column C.…We got spaces,…to many spaces between certain words,…like in Cell C5, C10.…We've got leading spaces in some of these cells.…There's one in C4,…there's another on in C10, C14 and so on.…These are going to cause big problems when we sort data.…We might even have trailing spaces.…The problem there could be if formulas relate to cells…that have trailing spaces,…they're not going to match up with other cells…that might look identical…but one might have trailing spaces the other one doesn't.…

And by the way,…when you click in the cell if you happen to click…where the text is,…double click to edit for example,…you don't necessarily know if there's a trailing space.…If you get in the habit of clicking on a cell,…on the right side beyond the text for example,…I'm about to double click in Cell C3,…I'm going to double click off to the right a bit,…double click,…we see the blinking cursor is well after the E.…