any EXCEL gurus here ?

[jackal]

would appreciate some help chaps

i have a long column with different forumlas in each cell

i want to append each formula with a small addition "+S16"

just so each cell adds another number onto its value as well

I tried selecting all cells and using CTRL + Enter but whilst it added the new "+S16" it also changed some of the formulas and messed then all up ?


does anyone know a good way to append or add/tag onto the end of a load of call formula ?

cheers

Rich

[mft]

Wouldn't the easy way would be to insert a new column next to the one you're trying to alter, and simply perform the addition (=<original cell>+$S$16) there, before (if necessary) hiding the original?

[T84]

Try "=concatenate(A1,"S16")" and then dragging that down, selecting the whole concatenate column, and then copy, paste special, "formulas" ?

[ccr32]

jackal said:

I tried selecting all cells and using CTRL + Enter but whilst it added the new "+S16" it also changed some of the formulas and messed then all up ?

Is S16 a constant that you want to add to every cell? If so, if you append the first formula in your long column of them with "+$S$16" instead, this will ensure that it is always this cell that is added.

[mike_knott]

T84 said:

Try "=concatenate(A1,"S16")" and then dragging that down, selecting the whole concatenate column, and then copy, paste special, "formulas" ?

Yep, but "=concatenate(A1,"+S16")"

Mike...

[cmackay81]

not 100% sure of what you need, but you either need this

' =A1+$S$6
(if you want to add the value of S6 to A1)
or

' =A1&"+S6"
(if you want to add the text of S6 to the end of A1)

then drag that column down, then select the entire column,select copy, then select paste special,and tick the values box.