From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Clean up spaces quickly with the TRIM function

Clean up spaces quickly with the TRIM function

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Clean up spaces quickly with the TRIM function

“

- [Voiceover] We're looking at the worksheet called HR List - spaces. And as you look in column C, you can see there're some problems. We've got some leading spaces in front of these. Sometimes these don't emerge until we sort data. You might have had some entries down around 200 or whatever with leading spaces, we wouldn't see those necessarily. But if we sort the data, we're going to have a problem. And there're other potential problems too. Any time we're trying to make comparison with data in one column or another or trying to match up words in text entries, if there's a trailing space or a leading space in one location and not the other, we're not going to get a match. And sometimes we see too many spaces between words. All of these can be cleaned up with the function called TRIM. Let's show what happens, first of all, if we sort the data. I'll just click in column C, go to the Data tab, click the A-Z button. There's the data and we see these problems. Now there could be farther…

Contents