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
|