Hi,

I have insert file name in my execl file by using below formula

=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-24)

it is working nicely. But when i opening multiple file at a time, then all file name are showing same name-
like
(may file name) 571 RU__274880__S.SUHI-47
when i open another file like this file 572 CH__274880__S.SUHI-47 then all file name should be shown same name like 571 RU____ etc.

So, please help