Removing spaces quickly to clean up data

- When you're working with list-type data,…you can run into big problems if you've got…leading spaces, trailing spaces,…sometimes multiple inner spaces.…In this worksheet called, "HR List Spaces,"…if we look at column C, we recognize…we've got some problems there.…Looks like a leading space in that…second entry right here, in cell C3.…Too many spaces between Quality and Assurance,…and too many spaces between Manufacturing and Admin.…We don't necessarily see trailing spaces here,…but there might be some,…and that could cause problems.…

Not by way of sorting, but if we're trying to…make some comparisons.…Now, depending upon where these occurred,…and if we were at a zoom factor…that was much lower, we might not see these.…Probably see some of these,…but the list might have been in a different order.…And so sometimes these do not emerge…until we do sorting.…So let's imagine we want to…sort this list based on what's in column C.…A fast way to do this, shown in the previous movie,…was simply from the standard toolbar,…