Can anyone see whats wrong with this formula?

=Y2&CHAR(10)&Z2&CHAR(10)&AA2&CHAR(10)&AB2&CHAR(10)&AC2&CHAR(10)&AD2&CHAR(10)&AE2&CHAR(10)&AF2&CHAR(10)&AG2&CHAR(10)&AH2

as when i copy & paste it down the sheet it will not change the formula and only brings up the same info in the 1st cell

Cell references change for me when I copy down the page?

Doh sorry, re read now. Don’t copy and paste the formula, drag the cell contents down then the cell references will change.

Are you doing a straight copy/paste or dragging the formula down using the cross on the bottom right of the cell?

edit: as above

even when i drag down it still uses the 1st cell info

yeah straight copy & paste and just tried dragging down

does the formula change when you check the formula bar (i.e. enter forumla in say A1, then copy/drag down to A2, A3, A4 – if you click A4 has the formula changed in from what your entered in A1?)

What are you expecting to see at the “output”? Depending on the cell height you may (I’ve not tested it) only see the content of Y2 (because then it is followed by a line feed).

all the cell references are relative, so they will move down when you copy down.

Obviously if Y2 has the same info as Y3, Y4 etc. then you’ll get the same ‘answer’…

..but if that’s not the case then the only reason I can see why the references might not move down is if the sheet is set to manual calculation and thus is not re-calculating the sheet when things change.

how would i kow if it set to manual calculation?

Tools > options> calculation

stick to the day job

cheers guys all working now thanks

Not having a good day 🙁