View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default Insert file name into sheet

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 ***