Concatenation and Copy Down

  • Thread starter F. Lawrence Kulchar
  • Start date
F

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
 
R

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
 
S

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top