Filling a series into a non-empty column
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
On Sat, 18 Aug 2007 09:00:03 -0700, Kathleen
wrote:
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!
|