Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you change the relative reference of a cell in an Excel formul | Excel Discussion (Misc queries) | |||
Adding the same number to each cell in a column | New Users to Excel | |||
adding number in next cell | New Users to Excel | |||
Is there a function to determine whether a cell contains a formul. | Excel Worksheet Functions | |||
can you use a variable or cell reference in a getpivotdata formul. | Excel Worksheet Functions |