|
| |
Microsoft Office
Using Find and Replace
Description
The Find and Replace feature of the Microsoft Office
software can be used to quickly search for and then replace text or
numbers in a file.
In the example shown below, we will find all instances
of 2005 in an Microsoft Excel file and replace it with 2006. You can
also use the Find and Replace command in Microsoft Word, PowerPoint,
Publisher or Access.
In any Microsoft Office Application
Menu Path
Replace Dialog Box
-
In the Find What box, type the text or numbers you
want to find
-
In the Replace With box, type the replacement text or
numbers
-
Click the Options button to further define your
search
Replace Dialog Box
Replace Dialog Box - Options
-
Use the Format buttons to base searches or
replacements on the formatting properties of a cell. For example, you
only want to replace the year 2005 if the number is displayed in bold
format.
-
From the Within drop down list, you can select either
Sheet or Workbook to search a single sheet tab or an entire workbook
-
In the Search drop down list, click the direction you
want to search: down By Columns or across By Rows
-
Click the check box next to Match Case if you want to
find text that matches the exact combination of upper and lower case letters
that you typed in the Find What box
-
Click the check box next to Match Entire Cell Contents
if you want to search for an exact and complete match of characters
specified in the Find What box
Replace Dialog Box - Options
Complete the Find and Replace
-
Click the Find Next button to find the first
occurrence of the text or numbers
-
Do one of the following:
-
Repeat the above steps until you have reached the end of
your file, then click the Close button
Replace Dialog Box
|
