View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Janis Janis is offline
external usenet poster
 
Posts: 360
Default adding a formul to the next cell only with the next cell number

Okay to make sure there are no trailing spaces and garbage I did this on one
cell.
clean(trim(a2))

What I want to do is add this formula to the whole column. I try double
clicking the cell to add this formula to all the subsequent cells and it
changes them all to a2, instead of making it clean(trim(a3))
clean(trim(a4))
clean(trim(a5))etc.

How do I make it like this instead of like this?
clean(trim(a2))
clean(trim(a2))
clean(trim(a2))
etc.

thanks,