Getting only the filename with no extension

[Barry Clark]

This code

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

works almost perfect for my needs; however, I need it to drop the extension to where only the name of the name of the file is left.

Any thoughts?

Thanks!

[Barry Clark]

Wouldn't you know, I found it.

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

[bj]

if all of the extensions are three characters try
=left(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1),len(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1))-4)

"Barry Clark" wrote:

>
> This code
> Code:
> --------------------
> =MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)
>
> --------------------
> works almost perfect for my needs; however, I need it to drop the
> extension to where only the name of the name of the file is left.
>
> Any thoughts?
>
> Thanks!
>
>
> --
> Barry Clark
> ------------------------------------------------------------------------
> Barry Clark's Profile: http://www.excelforum.com/member.php...o&userid=35267
> View this thread: http://www.excelforum.com/showthread...hreadid=555713
>
>