View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
coasterdude
 
Posts: n/a
Default Replace data in a column

How can I replace data in a column that is between 1 and 10? This way it will
leave any other text there. I think the whole column is formatted as TEXT so
I may be running into a problem there. Will I still be able to create some
sort of formula

If data 1 or <10 then replace with " "

--
Thanks