Getting a string of data from a file name
 

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

--
Stephen King
Also devices Pty Ltd
ACC Brisbane
Australia

Getting a string of data from a file name
 

If filepath is in cell A1 try

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

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=564582

Getting a string of data from a file name
 

thank you very much saved me a lot of searching.

--
Stephen King
Also devices Pty Ltd
ACC Brisbane
Australia
"Dav" wrote in message
...

If filepath is in cell A1 try

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

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=564582