Mark Hensler — Fri, 23 Mar 2001 07:16:33 +0000

Excel has a built in formula builder/helper thingy...

Type = in a cell, then look up near the top.
You should see a function in a dropdown menu on the far left (with a red X and a green checkmark to the right of it).
Click the down arrow, and select "More Functions..."
Now find the appropriate category on the left ("text" in this case), and find the function you need on the right.

"Give a man a fish, and he'll eat for a day. Teach a man how to fish, and he'll eat for a lifetime." - some wise guy

Brian Farkas — Fri, 23 Mar 2001 05:56:40 +0000

Thanks anyway-
I got a reply from somebody else that explained how to do it... For future reference:

=LOWER(CONCATENATE(A2, ".jpg"))

Replace A2 with the starting cell

Thanks,
Brian