function to return part of a string

I have a cell that returns the file name and I want to extract a piece of that for another cell.

C:\Documents and Settings\My Documents\[Workbook.xls]Worksheet

Is there a function that will return the part between the brackets (Workbook.xls)? I thought about using the MID function, but the file location changes and I can't always count on the workbook name being in the same starting position each time.

I seem to recall Excel being able to search for a particular character - in this case the bracket [ - and returning anything after that, but I don't remember the function.

Or better yet, is there a function that will give me JUST the workbook name without the full filepath?

Any ideas?

Thanks!

-sara

Thanks. Worked perfectly!