File Name

[atuljadhav]

Dear Sir

pl give me formula (not a VBA Code) that insert file name automatically

 

[VoG]

The file must first be saved for this to work

=CELL("filename",A1)

 

[atuljadhav]

it's not working
it show path of file
i want just file name only

 

[VoG]

Try

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

 

[anandvarma]

try this formula

=MID(CELL("filename"),FIND("[",CELL("filename"))+1,((FIND(".",CELL("filename"))+5)-(FIND("[",CELL("filename"))+1)))

 

[Rick Rothstein]

Here is a different formula to try, but it requires you to type in the worksheet name the formula is on manually. Also, it requires your path/filename to not have multiple adjacent spaces.

=TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(CELL("filename",A1),"]Sheet1",""),"[",REPT(" ",260)),260))

 

[anandvarma]

Here is a different formula to try, but it requires you to type in the worksheet name the formula is on manually. Also, it requires your path/filename to not have multiple adjacent spaces.

=TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(CELL("filename",A1),"]Sheet1",""),"[",REPT(" ",260)),260))

the formula fails if the sheet name is not "Sheet1"