Select the range of cells, worksheet, or workbook where you want to replace text
Press Ctrl + H to open Find and Replace
In the Find what box, enter the text or value you want to replace
In the Replace with box, enter the new text or value
Click Find Next to review matches one by one
Click Replace to change the current match
Click Replace All to change all matches at once
Use Options to set search within sheet or workbook, match case, or match entire cell contents
Click Close when finished