Join Dennis Taylor for an in-depth discussion in this video Correct multiple misspellings, part of Excel 2016: Cleaning Up Your Data.
- [Instructor] One of the inaccuracies…that occurs in lists is a misspelling,…and it happens frequently,…and it makes data, in some cases, look unprofessional.…As you look at the data here on this worksheet, called HR,…you might already have seen that in cell C3…environmental has been misspelled.…There's supposed to be an n right in front of the m, there.…Not everybody catches that,…it's not horrible, we've seen worse mistakes.…Down here, same thing happened.…Column B looks okay, although some of you…might have seen Mane, probably is a misspelling, M-A-N-E.…That could be somebodies name,…but here's a Mane up here, so we've got some issues.…
But if you want to use Excel's spell check feature,…you want to confine it to a certain location.…If we click on the upper left hand corner…and start using spell check,…we might get spell check working in column A, as well.…But with some of those unusual names there,…we might get some indicators.…Now, it's a little bit strange to know what's built in.…If we were to do a spell check on column A only,…
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