Hello Everyone,

Excel 2007

I am new to this group and have only been using excel for a few
years. I am reading "Excel 2007 the missing manual" to help further
my understanding of the program.


I have a question about how to format a formula:

Information:
Contents of A2 = 25013.JPG

What I would like as the end result:

<a href="graphics/00000001/hi-rez/25013.jpg"
<img src="graphics/00000001/hi-rez/25013.jpg" width="150"
</a

What I have so far:

=IF(A20,"<a href=graphics/00000001/hi-rez/"&LOWER(A2),"""")

I just don't know where to go from here?

Thank you for your help.

David