Can this be done in Excel?

[LawyerRon]

I have a cd with about 2,000 jpg photos on it. I need to get the file names only of all 2,000 jpg photos into an Excel spread sheet. In other words, I need a “list” of all the filenames in Excel. Is there some way to bring them (the filenames) into Excel without having to “copy and paste” each filename into a cell in Excel?

[glc]

http://j-walk.com/ss/excel/usertips/tip077.htm

You can modify the directory listing accordingly - example -

dir d:\*.jpg /s /b >c:\filename.txt

[LawyerRon]

Cool. Thanks g!

[LawyerRon]

OK, I got that to work, but I have another question. I was able to create the txt file and open it in Exel. However, the photo filenames have the path in front of them, eg: c:\photo.jpg. How do I quickly remove the path name in front of the photo's filename in Excel? The path name is the same in front of every photo's filename.

[faulkner132]

Assuming your path is always c:\ and the filename is in column A, this formula would work:

=MID(A1,4,100000)

The middle number (4) controls where you start the resulting string from, the 100000 is the length, so this assume you have no file names over 100000 characters.

If your files were in c:\photos\picture.jpg, this would work:

=MID(A1,11,100000)

[LawyerRon]

Thanks. I'll give it a try.

[glc]

How about opening the text file in Word and using Edit - Replace and replacing c:\ with nothing? That should even work directly in Excel too.

[LawyerRon]

Yeah, that sounds good too.