How to find and mass replace text and numbers in Word andExcel 2016?


If you have used Microsoft Word or Excel at school or work, you might have realized that it’s a bit challenging to mass find and replace certain text or numbers automatically. This is exactly, what we’ll show you in today’s quick tip.

Word:

  • Open Microsoft Word document.
  • Enter the data in word document .
  • To replace a word with another word,click on home tab and then click editing option.
  • Click replace option under editing group.

3

 



  • In the Find what box, enter the text you want to replace.
  • In the Replace with box, enter the replacement text.

rename 3

 

  • To replace only the highlighted text click Replace option.
  • To replace all instances of the text in the entered document, click Replace All.
  • To skip from present highlighted text to next instance, click Find Next.

Excel:

  • Open your Microsoft Excel workbook.
  • To replace a word with another word,click on home tab and then click Editing option.
  • Click replace option under editing group.

3

  • In the Find what box, enter the text you want to replace.
  • In the Replace with box, enter the replacement text.

rename 3

  • To replace only the highlighted text click Replace option.

rnw4

  • To replace all instances of the text in the entered document, click Replace All.
  • To skip from present highlighted text to next instance, click Find Next.

rnw5

  • Hence the same process can be continued for changing any type of words for the entered data.
  • Mass Replace in PowerPoint works in a similar fashion.

Thansk for reading.

Leave a Comment: