Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need help
I have a column full of photo names such as 2801.JPG. There are around 500+ image names in this column. What I need to do is add "photos/" in front of every image name in this column; e.g. "photos/2801.JPG". Is there any way to do this other than one at a time. It would take a very long time doing it this way. Thanks for your help example: _current_ 2801.jpg 2802.jpg 2803.jpg _What_I_need_ photos/2801.jpg photos/2802.jpg photos/2803.jpg -- trimax ------------------------------------------------------------------------ trimax's Profile: http://www.excelforum.com/member.php...o&userid=35247 View this thread: http://www.excelforum.com/showthread...hreadid=550235 |