find and replace
i didn`t get the use of find and replace function ,why i`m using it?
i`m so sorry
We need Find and Replace when we want to substitute multiple types one type of input in an Excel sheet with another.
Imagine you have a sheet in which the year 2021 is cited many times. You want to change it with 2022, but you don't want to go through each cell and change the number once at a time. In this case, you can simply do a find and replace and substitute all 2021 values with 2022.