Hi All

Im new to excel and was wondering about the following:

In one of the columns i have to put the same information except for the
number at the end, eg example1, example2, example3 etc.

Is there something on excel that will add what i want with the number
from 1-1000? Even if it put a space that i could later remove would
help.

Thanks


--
noidea
------------------------------------------------------------------------
noidea's Profile: http://www.excelforum.com/member.php...o&userid=36491
View this thread: http://www.excelforum.com/showthread...hreadid=562504

noidea,

In A1 type in "example1". Select your range to 1000. Go to
Edit>Fill>Series and select AutoFill. Click OK.



HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=562504

Try something like this:

Cell A1: Example1

Left-click and hold on the drag handle of cell A1
(the little black box in the lower right)

Drag down (while holding down the left mouse button)
You should see the series increment...Example1, Example2, etc
Release the mouse button when done.

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=562504

Thanks Steve, that worked a treat!


--
noidea
------------------------------------------------------------------------
noidea's Profile: http://www.excelforum.com/member.php...o&userid=36491
View this thread: http://www.excelforum.com/showthread...hreadid=562504

noidea wrote:
> Hi All
>
> Im new to excel and was wondering about the following:
>
> In one of the columns i have to put the same information except for the
> number at the end, eg example1, example2, example3 etc.
>
> Is there something on excel that will add what i want with the number
> from 1-1000? Even if it put a space that i could later remove would
> help.
>
> Thanks
>
>
> --
> noidea
> ------------------------------------------------------------------------
> noidea's Profile: http://www.excelforum.com/member.php...o&userid=36491
> View this thread: http://www.excelforum.com/showthread...hreadid=562504

Hi,

If you enter example1, example2,example3 in cells A1, A2 and A3.
Then highlight all 3 cells and click on the little black square in the
buttom left corner of the highligted array. Then keep pressing down the
left mous button and drag down to A1000

It should fill in with example4, example5 etc. etc..

Regards,
Bondi

Thanks Ron!

You guys have saved me typing loads of repetitive stuff!

Really appreciate your quick replies.


--
noidea
------------------------------------------------------------------------
noidea's Profile: http://www.excelforum.com/member.php...o&userid=36491
View this thread: http://www.excelforum.com/showthread...hreadid=562504