View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DW
 
Posts: n/a
Default 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.