Concatenation and Copy Down

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

F. Lawrence Kulchar - 31 May 2008 20:57 GMT

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

Reply to this Message

RagDyeR - 31 May 2008 21:11 GMT

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

Signature

HTH,

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

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

Reply to this Message

Sandy Mann - 31 May 2008 21:15 GMT

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

Signature

HTH

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

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> If in Cell A1, I have the word: "LOVE", what is the best way to copy down
> through cell A1000...
[quoted text clipped - 10 lines]
>
> FLKulchar

Reply to this Message