Automatically adding image extension ".jpg" to end of image name

Hi,

Someone please tell me how I can set up my Excel document to automatically
add the ".jpg" extension at the end of every image name, which I can then use
in a mail merge catalog (Publisher) instead of physically having to type it
at the end of every word. Thank you in advance.

Al

Say you have your list of images in A1:A99.

You can use a formula in B1 (and copy down to B99):

=a1&".jpg"



Alain wrote:
>
> Hi,
>
> Someone please tell me how I can set up my Excel document to automatically
> add the ".jpg" extension at the end of every image name, which I can then use
> in a mail merge catalog (Publisher) instead of physically having to type it
> at the end of every word. Thank you in advance.
>
> Al

--

Dave Peterson