Concatenation and Copy Down

[F. Lawrence Kulchar]

If in Cell A1, I have the word: "LOVE", what is the best way to copy down
through cell A1000...

LOVE2
LOVE3
LOVE4
....
....
etc.
LOVE1000

Thanks,

FLKulchar

 

[RagDyeR]

Key in
Love2
Into A2, click on the fill handle, and simply drag down.


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================



message If in Cell A1, I have the word: "LOVE", what is the best way to copy down
through cell A1000...

LOVE2
LOVE3
LOVE4
....
....
etc.
LOVE1000

Thanks,

FLKulchar

 

[Sandy Mann]

Enter LOVE1 in A1 then drag down on the fill handle then delete the 1 cell
A1

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk