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

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

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