software

We have a rather large spreadsheet would like to find only 13 amp; 23 (numbers)
and replace with quot;Yesquot; (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.

Try this:

lt;Editgt;lt;Replacegt;
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-Proquot;DWquot; wrote:

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