Fill Down
="C:\Documents and Settings\User\My Documents\Pictures\"&ROW(1:1)&".jpg"
"FSt1" skrev:
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
"Freddy" wrote:
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.
|