Getting a string of data from a file name

[Stephen King]

I need to extract a persons name from a cell that has the filename
for instance =cell("filename") will return T:\actdata\act\excelshets\[abbey
roberts gymstart progress 2006.xls]sheets1
I want just the name I.e abbey roberts
the thing is that name can vary in length I have tried left right and I can
do it in 2 steps using left then right but I cant do it as one formula.


hope you can make sense of that.

TIA

 

[Dav]

If filepath is in cell A1 try

=MID(A1,FIND("[",A1)+1,FIND("gym",A1)-FIND("[",A1)-2)

Regards

Dav

 

[Stephen King]

thank you very much saved me a lot of searching.