| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set an 'M' prefix to existing text in a column? | New Users to Excel | |||
| prefix a column of numbers with combination of zeros | Excel Discussion (Misc queries) | |||
| Adding a prefix to all numbers in a column. | Excel Discussion (Misc queries) | |||
| how do i prefix a column with letters | Excel Discussion (Misc queries) | |||
| Prefix macro | Excel Programming | |||
Hybrid Mode
