find and replace
i didn`t get the use of find and replace function ,why i`m using it?
i`m so sorry
4 answers ( 0 marked as helpful)
Hey Samar,
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.
Best,
Ned
Ahaaa i get it with the example you provided.
thank you so much
are you have the meaning of references of cells content ?