Join Dennis Taylor for an in-depth discussion in this video Using text functions, part of Cleaning Up Your Excel 2013 Data .
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…
Released
7/7/2014- Moving or inserting rows and columns of data with a simple drag
- Transposing row-column layouts into column-row layouts
- Replacing data at the character level
- Dealing with special characters and wildcards during search and replace
- Converting dates with text functions
- Converting text data to values/numbers
- Checking and correcting spelling mistakes
- Splitting data into multiple columns via the Text to Columns feature
- Combining data from different columns via concatenation or Flash Fill
Share this video
Embed this video
Video: Using text functions