This codeworks 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.Please Login or Register to view this content.
Any thoughts?
Thanks!
This codeworks 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.Please Login or Register to view this content.
Any thoughts?
Thanks!
Wouldn't you know, I found it.Please Login or Register to view this content.
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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks