add prefix to filename - macro to loop down column
 

Hi! What's the best way to change a column of cells that contiain
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
can afford to try and figure it out. Think this is an easy one fo
experienced users hopefully!

Thanks for any input! :)
Cind

--
cml090
-----------------------------------------------------------------------
cml0904's Profile: http://www.excelforum.com/member.php...fo&userid=3773
View this thread: http://www.excelforum.com/showthread.php?threadid=57320

add prefix to filename - macro to loop down column
 

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

add prefix to filename - macro to loop down column
 

thanks much, works perfect

--
cml090
-----------------------------------------------------------------------
cml0904's Profile: http://www.excelforum.com/member.php...fo&userid=3773
View this thread: http://www.excelforum.com/showthread.php?threadid=57320