use

=A2&"-a.jpg"
=A2&"-b.jpg"
=A2&"-c.jpg"

and copy down

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Swn-Y-Mor" wrote
in message ...

I have a spreadsheet where I have an Item Ref number and 3 associated
images.

eg.

Item Ref Image1 Image2 Image3
2800 2800-a.jpg 2800-b.jpg
2800-c.jpg

I now need to add 500 more images, and was wondering if someone knew of
a way for me to add the Ref No. and Image1 Image2 Image3 are filled in
by taking the Ref No and adding -a.jpg , -b.jpg , -c.jpg to it. Hope I
explained what I am trying to achieve.


Item Ref Image1 Image2 Image3
2800 2800-a.jpg 2800-b.jpg
2800-c.jpg
2801 2801-a.jpg 2801-b.jpg
2801-c.jpg
2802 2802-a.jpg 2802-b.jpg 2802-c.jpg


--
Swn-Y-Mor
------------------------------------------------------------------------
Swn-Y-Mor's Profile:
http://www.excelforum.com/member.php...o&userid=18359
View this thread: http://www.excelforum.com/showthread...hreadid=517774