Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2001
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Returning FIle Names (Excel 2000 SP-3)

    In trying to get Excel to return the file name in a cell from a function, I can

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Returning FIle Names (Excel 2000 SP-3)

    Hi

    The following formula was taken from Chip Pearson's site

    =MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

    You can also use a user defined function to obtain the filename, see Ozgrid for an example.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •