Need help

[trimax]

I have a column full of photo names such as 2801.JPG. There are aroun
500+ image names in this column. What I need to do is add "photos/" i
front of every image name in this column; e.g. "photos/2801.JPG". I
there any way to do this other than one at a time. It would take a ver
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.jp

 

[FSt1]

hi,
=concatinate("Photos/",a2)
copy down then copy all and paste as values
regards
FSt1

 

[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