Fill Down

F

Freddy

Sorry, sent the previous message incorrectly.

I would like to fill down so only one character changes sequentially, like
this:

C:\Documents and Settings\User\My Documents\Pictures\1.jpg
C:\Documents and Settings\User\My Documents\Pictures\2.jpg
C:\Documents and Settings\User\My Documents\Pictures\3.jpg
C:\Documents and Settings\User\My Documents\Pictures\4.jpg

Any assistance is appreciated.
 
F

FSt1

hi.
you might have to use a helper column. in the helper column, put a range of
numbers 1 throught whatever... a 100 maybe. then in the column where you
want your file paths, enter this formual.....
="C:\Documents and Settings\User\My Documents\Pictures\" & A1 & ".jpg"
="C:\Documents and Settings\User\My Documents\Pictures\" & A2 & ".jpg"
="C:\Documents and Settings\User\My Documents\Pictures\" & A3 & ".jpg"
="C:\Documents and Settings\User\My Documents\Pictures\" & A4 & ".jpg"
and so on.

hope this helped
Regards
FSt1
 
T

Teethless mama

="C:\Documents and Settings\User\My Documents\Pictures\"&ROW(A1)&".jpg"
copy down
 
E

excelent

="C:\Documents and Settings\User\My Documents\Pictures\"&ROW(1:1)&".jpg"


"FSt1" skrev:
 
Top