add prefix to filename - macro to loop down column

Hi! What's the best way to change a column of cells that contiain a filename such as myimage.jpg and add the full path -- http://www.mydomain.com/images/myimage.jpg?

I assume some type of looping macro, but have spent way longer than I can afford to try and figure it out. Think this is an easy one for experienced users hopefully!

Thanks for any input!
Cindy

How about just using a formula:

="Http://www.domain.com/images/" & a1

and drag down

Maybe better...

=hyperlink(""Http://www.domain.com/images/" & a1,"Click me!")

and drag down.

cml0904 wrote:
>
> Hi! What's the best way to change a column of cells that contiain a
> filename such as myimage.jpg and add the full path --
> http://www.mydomain.com/images/myimage.jpg?
>
> I assume some type of looping macro, but have spent way longer than I
> can afford to try and figure it out. Think this is an easy one for
> experienced users hopefully!
>
> Thanks for any input!
> Cindy
>
> --
> cml0904
> ------------------------------------------------------------------------
> cml0904's Profile: http://www.excelforum.com/member.php...o&userid=37730
> View this thread: http://www.excelforum.com/showthread...hreadid=573204

--

Dave Peterson

thanks much, works perfect!