Hi,

I'm having trouble getting the autofill option to use the correct references. My problem is that my intuition and Excels intuition disagree

So, here's an example

Column B is filled with Data. In the Cells in A I want to cells to be represented by a line break ( CHAR(10)). So what I want:

____ l A l

1 =B8 & CHAR(10) & B9
____

2 =B10 & CHAR(10) & B11
____

3 =B12 & CHAR(10) & B13
____

etc..


What Excel thinks I want (by filling out A1 and using autofill function):

____ l A l

1 =B8 & CHAR(10) & B9
____

2 =B9 & CHAR(10) & B10
____

3 =B10 & CHAR(10) & B11
____


Any solution to this problem?