View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kathleen Kathleen is offline
external usenet poster
 
Posts: 44
Default Filling a series into a non-empty column

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!