How do I insert a date created in a cell in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to insert the file name in a cell. I don't want the entire path,
just the file name. Please help!
 
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
date format error in cell 1
Excel Worksheet_change with 2 functions to insert date and hyperlink window 0
display date of today in cell X when number >0 in cell Y 2
Excel Excel - Macro to Insert Cell 0
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1

Back
Top