Cell value as filename

C

chas975

I am trying to find a way to make a "cell value" read the "filename"
automatically. Similar to how you autoformat a footer to read the
filename. Can anyone offer any advice?
 
P

papou

Hello
Formula in A1 :
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,SUM(FIND({"[";"]"},CELL("filename",A1))*{-1;1})-1)
nb: workbook must be saved

HTH
Cordially
Pascal

"chas975" <[email protected]> a écrit
dans le message de (e-mail address removed)...
 

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

Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
get value of cell only 6
Insert file name in header without showing extension 1
Filename in Excel Cell Address 7
macro to print xps then save with name value in (B2) 8
Cell value as filename 1
Getting sheet name and info from cell 3
Sheet Names and Auto-calculation 2

Top