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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need help
hi,
=concatinate("Photos/",a2) copy down then copy all and paste as values regards FSt1 "trimax" wrote: 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need help
The CONCATENATE function was mis-spelt. A slightly simpler way is:
="photos/" & A2 then copy down as FSt1 suggests. Hope this helps. Pete FSt1 wrote: hi, =concatinate("Photos/",a2) copy down then copy all and paste as values regards FSt1 "trimax" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|