Join Dennis Taylor for an in-depth discussion in this video Correcting multiple misspellings, part of Cleaning Up Your Excel 2010 Data.
Excel has a built-in spellchecker, and I highly recommend that you use it before…either printing your work sheet or possibly displaying it in a public forum.…A sharp-eyed observer out there might immediately see that environmental has been…misspelled here in cell C3--it might have been misspelled elsewhere.…Let's apply the Spellchecker.…It's found on the Review tab, the leftmost button.…Possibly you might want to check all of your data here.…For the moment, maybe just column C, activate spellchecking.…There we see environmental, the correction, and we would certainly want…to Change All here.…
So we see it in C3. It's also in cell C10, and perhaps later, too; we don't know necessarily.…Let just change all of them.…It gets the job done quickly.…Now there's some other aspects of spellchecking that go beyond actual spelling.…I put the word Monday out here as a reminder that if you type in any day of the week--…I'm going to type in Monday--…now I haven't capitalized it, but what happens when I press Enter or Space or…
- Moving or inserting rows and columns of data with a simple drag
- Using Text to Columns
- Harnessing the Find and Replace command to replace data at the character level
- Dealing with special characters and wildcards during search
- 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
Skill Level Intermediate
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.