How to Replace Multiple Values in Excel
This guide provides step-by-step instructions on how to replace multiple values in Excel. It is helpful for anyone who needs to quickly and efficiently replace specific values in their Excel spreadsheet.
Adrienne Todd
|
6 steps
|
16 seconds
1
In the "Home" tab, click "Find & Select" in the ribbon.
2
Click "Replace..." in the dropdown menu.
3
Type the value you'd like to replace in the "Find what" field.
4
Type your replacement value in the "Replace with" field.
5
Click "Replace All."
6
Click "OK."