Question

write a short note on find and replace option in ms excel​

Answer 1

To replace cell content:

From the Home tab, click the Find and Select command, then select Replace from the drop-down menu. The Find and Replace dialog box will appear. Type the text you want to find in the Find what: field. Type the text you want to replace it with in the Replace with: field, then click Find Next.