|
Getting only the filename with no extension
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 |
Getting only the filename with no extension
Wouldn't you know, I found it. Code: -------------------- =MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND(".",CELL("filename", A1))-FIND("[",CELL("filename",A1))-1) -------------------- -- 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 |
Getting only the filename with no extension
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 |
| All times are GMT +1. The time now is 09:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com