Filling a series into a non-empty column

[Kathleen]

Is it possible to take a series, such as the Item Number example below, and
then filling it into a column that already has text in it?

What I want for it do is input each item into the Image column, where it
will result in "products/1.jpg, products/2.jpg. products/3.jpg, etc."


Item Number
1
2
3
4
5

Image
products/.jpg
products/.jpg
products/.jpg
products/.jpg
products/.jpg

Thank you in advance for your help!

 

[Gord Dibben]

I would do it this way.

Numbers in column A

In B1 enter ="products/" & A1 & ".jpg"

Double-click on the fill handle of B1 to copy down.


Gord Dibben MS Excel MVP