inputting filename into a cel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

ive got the following in my workbook;

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

is there anyway of getting it to remove the .xls that appears at the end?
 
Hi Andy

one way:

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

Cheers
JulieD
 
Back
Top