Find specific number and replace with "Yes"
 

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.

Find specific number and replace with "Yes"
 

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


"DW" wrote:

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.