Join Dennis Taylor for an in-depth discussion in this video Use text functions, part of Excel 2016: Cleaning Up Your Data.
- [Instructor] Cleaning up text data…does have the advantage of many different…Excel functions called text functions.…In this worksheet, called Text Functions…in our Chapter five file,…we've got some data in column A.…Nothing too terribly wrong with it,…except it's all uppercase, and that's not what you want.…You want just the first letters…of the names to be capitalized.…And we can do this is a number of different ways.…In later movies, the flash fill…feature might be your best choice,…but in the example here, let's say we…are only concerned about the capitalization.…
We've got a similar situation in column D,…but there we also have a space issue.…Let's deal with the entry in column A.…The function here is called proper.…We're looking at the data in cell A2.…We only want the beginning letters to be capitalized,…but also the B in O'Brien.…What's going to happen here?…Well, I think the task is done.…It even capitalized the B in O'Brien.…The function is called proper.…It uses lowercase for all the other letters,…and by definition, the proper function capitalizes…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Moving and inserting rows and columns of data with a simple drag
- Replacing data at the character level
- Converting dates with text functions
- Converting text data to values
- Using the CONCAT and TEXTJOIN functions to combine data
- Splitting data into columns via the Text to Columns feature
- Using Flash Fill for faster combining and splitting
- Checking and correcting spelling mistakes