Help with the Fill tool please

**tadwestie** · 01-03-2010, 06:23 PM

Help with the fill fomula, I need help to add a url infront of a photo file. Doing spread sheets for google base and need to add our url in front of the image url for the finished spread sheet. How do I work the fill so I do not need to hand submit to each 600 lines please

**tadwestie** · 01-03-2010, 06:30 PM

I do google base spreadsheets for our web site. In the format I need to have the description, title, the photo url, and the photo file. In front of the photo file url I need to put our web site address. How do I use the fill option to add the url in front of each image file url. This so I do not need to copy and past 620 items individually.

**teylyn** · 01-03-2010, 06:32 PM

Hi tadwestie,

welcome to the forum. Please post your questions in one of the questions forums. Read the forum rules to find out more.

I'll move and merge your two posts, but I expect you to follow the rules from now on.

cheers

**martindwilson** · 01-03-2010, 06:48 PM

with your image paths in say column a
then in column b
="www.my url/"&a1
drag down
you can then copy paste back special values to eliminate the formula.