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
 

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

problems getting this macro to work 23
Getting sheet name and info from cell 3
get value of cell only 6
Formula for naming tabs 10
filename search and extract into a cell 5
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Function to put worksheet name in cell returns text, need number 5
Change Filename in Macro 3

Back
Top