Insert file name in cells
Deare De Silva,
Try the following array formula (Ctrl+Shift+Enter)
=MID(CELL("filename"),MATCH("[",MID(CELL("filename"),ROW(1:150),1),0)+1,MATCH(". ",MID(CELL("filename"),ROW(1:150),1),0)-MATCH("[",MID(CELL("filename"),ROW(1:150),1),0)-1)
WHen you change the filename, i guess you would have to vlose and reopen the
file.
Regards,
Ashish Mathur
"Mohan De Silva" wrote:
I need to insert the file name in a cell of the work page (with a funtion)
and be able to change automatically if & when the file name id edited. I Use
this on a cover page .
|