Need help

[trimax]

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

[FSt1]

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
>
>

[Pete_UK]

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
> >
> >