Using text functions

In this worksheet called text functions, we've got…a number of issues in columns A, D, and F.…Not necessarily major, but worrisome…enough so that you want to change them.…The data in column A is all upper-case.…Nothing terribly wrong with that, but it certainly would…look better if just the first letters were capitalized.…And we can do this by way of the function called proper.…Now, proper is one of a number of functions…that fall into the category of text functions.…And in a related course, called formulas…and functions, you will see information…about a number of these particular functions.…

And off to the right in this particular…worksheet you'll see quite a few of these.…Some of these are being used in other…movies in this course, and you'll see…some in later movies in this chapter.…I won't mention every single one of them.…But these as a general category…are referred to as text functions.…And they have a lot to do with cleaning up data.…Also related to these is a new feature…called "flash fill," and you'll see that in a…