Showing Filename in Cell

N

Neil Holmes

Hi,

Can anyone help with how to return filenames in cells?

Thanks.

Neil Holmes.
 
P

Peo Sjoblom

One way

=LEFT(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255),FIND(".",
MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255))+3)

assuming you are using one period in the file name like in *.xls
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drag and Drop does not work Outlook for Mac 0
FileName 5
Merging from an Excel file with graphics 1
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Word macro that can call cells out of Excel for a find and replace 0
Newbie Help - IF Yes No Function 0
Working Days in a Named Month 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0

Top