Use Find and Replace to change cell contents and formats

- [Instructor] We're looking at a list … that has about 750 rows, an HR kind of list. … And we want to make some changes to it, … some wholesale changes. … First of all, we want to change full time … so that it has a dash in it. … So selecting Column D, and any time you're about to … replace data or try and find data … and you'll be using that Find and Select button … on the home tab, it's best to narrow down the search … or the replacement area to a single column … or a group of columns where the changes are to occur. … So find and select the magnifying glass … that used to be binoculars, let's replace. … We want to replace Time … with what? … Tab, dash, Time. … Now, I'm thinking full-time, but maybe I'm ignoring … or didn't look close enough to see … that half-time already has a dash in it. … So what am I saying? … Every time we see T-I-M-E, replace it with dash time. … Replace... … 488 replacements. … Well, we took care of the full-times. … They all have a dash now. … But what happens to the half-time? …