Last answered:

30 Dec 2022

Posted on:

10 Nov 2022

2

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)
Instructor
Posted on:

11 Nov 2022

0

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

Posted on:

11 Nov 2022

2

Ahaaa i get it with the example you provided.

thank you so much

Posted on:

30 Dec 2022

0

are you have the meaning of references of cells content ?

Instructor
Posted on:

30 Dec 2022

0

Hey Mahmoud, do you want to elaborate on your question, please?

Submit an answer