Find specific number and replace with "Yes"

D

DW

We have a rather large spreadsheet would like to find only 13 & 23 (numbers)
and replace with "Yes" (text). The problem is there are other numbers longer
in length that could potentially change by doing a search/replace. Is there
an easy way of doing this. Initially I looked at IF statements.
 
R

Ron Coderre

Try this:

<Edit><Replace>
Find what: 13
Replace with: Yes
Click the [Options] button
Check: Match entire cell contents
Click the [Replace All] button

repeat for 23

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top