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,

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

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

On Mon, 30 Jul 2007 12:26:00 -0700, Janis
wrote:

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,