Cleaning up spaces


show more Cleaning up spaces provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts show less
please wait ...

Cleaning up spaces

Extra spaces in data many times don't cause major problems, but occasionally they do. And it's increasingly a problem in these days of downloading data. In this particular worksheet here you might notice already here in cell C5 there are some extra spaces between the two words. That's probably not going to be a problem. But what happens if we sort this data? I want to click somewhere in column C here. Any cell could have stayed there. I'm going to click A-Z. The entire list is going to be sorted. And what do we see here? This ends up first.

It's got some leading spaces. This does too. We're not counting them exactly, but we see this. We scroll down a little bit, it looks like maybe we've got a few these. In fact, this list doesn't look like it has sorted at all, does it? And then eventually we see, oh yes, here it is. What's happening here? Notice if you look closely from this cell upward everything has at least one leading space. My zoom factor right now is 13...

Cleaning up spaces
Video duration: 4m 47s 3h 43m Intermediate

Viewers:

Cleaning up spaces provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts

Subject:
Business
Software:
Excel
Author:
please wait ...