Join Dennis Taylor for an in-depth discussion in this video Using additional Spelling options, part of Cleaning Up Your Excel 2010 Data.
In addition to standard spellchecking capability, Excel also has some…auto-correct features that go well beyond that capability and give you some real…tools for making your use of Excel more efficient.…In column E there's a few words here-- common words of course: "the," "and."…But commonly mistyped typos of course.…"Teh," you might be typing that;…you meant to type The.…Now that might be the first word in what you're about to type, it might be…between other words; but as soon as we either press Enter or punctuation or…Space, that automatically gets corrected.…
And if we have the word "and," you might mistype it as adn.…As soon as we hit Space, Enter, punctuation, that automatically gets corrected too.…Not quite so obvious though is the fact that the AutoCorrect capability also…includes a lot of misspelled words.…Now that's the correct way to spell accommodate. And it's probably not the most…commonly used word in Excel, but if you were to type that word--and probably it…wouldn't be the first word, but it could be--…
- 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 Appropriate for all
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.