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

David,

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

HTH,
Bernie
MS Excel MVP


"yovation" wrote in message
ups.com...
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

Thank you Bernie