Join Dennis Taylor for an in-depth discussion in this video Harnessing the Find and Replace commands, part of Cleaning Up Your Excel 2010 Data.
You can control both the correction of data and the replacement of it with the…efficient use of the Find and Replace commands found on the Home tab in the…Ribbon, and there is also a Replace function that we want to take a look at.…Let's imagine in this list here, in a problem list worksheet, some of the…statuses need to be changed.…This company has decided, for example, to change the term Hourly to Temporary.…So we don't necessarily need to sort the data;…we simply want to make a wholesale replacement.…Let's just select Column E-- that's where that data resides.…
And on the Home tab, the extreme right button with the Binoculars icon, Find & Select,…let's simply choose Replace.…So, what do we want to Replace?…Every time we see the word Hourly, and we want to replace Hourly with Temporary.…And we want to replace all of them, just like that.…54 of them have been changed. Fast and easy--could hardly be faster.…That's going to work for us.…You might similarly have a need for code changes as well.…
- 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.