Hello,
I am trying to create a formula which reproduces the text from one cell into another.
This works...
=C7
However, when I try and copy this cell and the formula, whilst the formulas follow suit, i.e. in D8 it says =C8; it retains the text from C7.
So you end up with something look like
C
7 John John
8 Andrew John
9 Billy John
It should of course look like...
C
7 John John
8 Andrew Andrew
9 Billy Billy
Anyone have any idea how I can fix this so I get the correct formula and the correct text?
Mike
Bookmarks