Prefix-text, Suffix-text

[barbiro]

Hi guys I'm hoping someone can help me.

I have a looooooooong row (D) with text, for example:

Snowman Candle Lamp
Painted Metal "Welcome" Wreath
Waiter Design Plate Set with Rack
Mini Sunburst Design Lamp Shade Candle
Blue Beaded Candle Lamp
Moroccan Design Amber Glass Candle Lantern

I want the entire row to commence with <h1> and end with </h1>, for example:

<h1>Snowman Candle Lamp</h1>
<h1>Painted Metal "Welcome" Wreath</h1>

Rather than go one-by-one down a very loooooooong column, I figured Excel must have a way of doing this. How would I set up a formula to do that? Use Congatenate? I'm just not sure how to set it up. My fingers would appreciate any feedback.

Thanks

[duane]

if this in for cell d5

<h1>Snowman Candle Lamp</h1>

then

=concatenate("<h1>",d5,"</h1>")

[barbiro]

That doesn't appear to work.