View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
belharris belharris is offline
external usenet poster
 
Posts: 3
Default how do I change all numbers to "1"

we have a massive excel spreadsheet downloaded from surveymonkey where values
in the columns range from 1 to 40 in hundreds of columns. I know how to
find/replace 1 number at a time like change all 2's to 1's. Is there a quick
way to change all numbers 2, 3, 4, ect to 1 with one swoop?