adding a formul to the next cell only with the next cell number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
I assume you have used an = sign.

=CLEAN(TRIM(A2))

Otherwise you are just filling text values.

If calculation mode is manual you will get the same values returned although the
cell refs should increment.


Gord Dibben MS Excel MVP
 
Back
Top