Trim


show more Trim provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Trim

Some of the functions in your function Library designed to help format information that is residing in cells. And the next function that we're going to look at, the Trim function's going to do just that. If you take a look at the information that's in column B, you'll notice that most of my values seem to be just ever so slightly in between the beginning of the cell, and where my letters start. And the only reason I notice that, is because as I come down I see they're not lining up properly. So I'd like to fix that. Now, one way I could do is to go into the cell, and take the cell, and you know, remove all the leading spaces, click Enter, and then it lines up nicely to the far left of the screen. But even doing it 25 times is far too many times than I want to do it. So what's an easy way that I could remove the leading zeros on all that information? Well, I can do that by using the Trim function. Now again, let's review how you work with your functions. You...

Trim
Video duration: 5m 2s 5h 13m Beginner

Viewers:

Trim provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

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