Assuming your =CELL formula is in A1
Enter the following in B1:
=MID(A1,SEARCH("[",A1)+1,SEARCH("]",A1)-SEARCH("[",A1)-1)
HTH
--
AP
"Darin Kramer" a écrit dans le message de
...
Thanks - but that inserts path as well as filename - is it possible just
to get file name?
Regards
D
*** Sent via Developersdex http://www.developersdex.com ***