J
Janis
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,
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,