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

[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,

 

[Gord Dibben]

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