You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.

3. Repeat the value above in Excel Depending on where you receive your data, you might find that some blank cells should contain the value in the cell above.