Cell discription as file name

**Onesock** · 10-23-2012, 09:52 AM

Hi Everyone

Could someone please tell me a formula to insert into a cell that will display the same discription as the file name.
Thanks

**mikerickson** · 10-23-2012, 10:05 AM

Try
=CELL("filename", A1)

**benishiryo** · 10-23-2012, 10:08 AM

hi Onesock. maybe try:
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

**Onesock** · 10-23-2012, 10:54 AM

Hi Mike

Unfortunatly the formula gives the whole path name - I just needed the file name.
Thanks for trying.

Regards

**Onesock** · 10-23-2012, 10:57 AM

Hi
Works great !! . Is there some way that it can work without showing the file extension in the file name . ie can it leave out the .xls

Hoping

**benishiryo** · 10-23-2012, 11:24 AM

how about:
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND(".xl",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

**:) Sixthsense :)** · 10-23-2012, 12:06 PM

Or

On Saved Workbook

Formula:

Please Login or Register  to view this content.

For 2003 use the below formula to get the file name and the notification message for unsaved workbook

Formula:

Please Login or Register  to view this content.

For 2007 use the below formula to get the file name and the notification message for unsaved workbook

Formula:

Please Login or Register  to view this content.

Hope that helps!

**:) Sixthsense :)** · 10-23-2012, 12:07 PM

Internet connection problem same post getting posted twice, so replacing the duplicate post with this message.

Regret for the inconvenience.

**Onesock** · 10-23-2012, 03:54 PM

Yip Thanks

That works exactly how I need it too !!!1

Re: Cell discription as file name