View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Automatically adding image extension ".jpg" to end of image name

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