If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel Filename in cell without the ".xls" extension
Hi all,
I have read the article that excel can auto insert the file name in a cell using this: =LEFT(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255),FIND(".", MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255))+3) which, for example, will return "abc.xls" in the cell if the file name is abc.xls If i want the cell to show "abc" only (without the extension xls) is there a way to do so? Thanks! -- |
#2
|
|||
|
|||
Excel Filename in cell without the ".xls" extension
See one answer in m.p.excel
Please don't post to multiple groups - it just tends to fragment your answers and to potentially waste the time of those replying to questions that have already been answered. For tips on using these groups effectively, see http://cpearson.com/excel/newposte.htm In article , "John Smith" wrote: Hi all, I have read the article that excel can auto insert the file name in a cell using this: =LEFT(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255),FIND(".", MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255))+3) which, for example, will return "abc.xls" in the cell if the file name is abc.xls If i want the cell to show "abc" only (without the extension xls) is there a way to do so? Thanks! |
#3
|
|||
|
|||
Excel Filename in cell without the ".xls" extension
See John McGimpsey's reply in microsoft.public.excel
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
stuck with Excel If function | Ken | Worksheet Functions | 1 | May 23rd, 2004 07:22 PM |
Excel Cell Format - Is there a way to force minutes with no hours? | Anders S | Worksheet Functions | 0 | May 22nd, 2004 12:12 AM |
cell limitations | Harlan Grove | Worksheet Functions | 0 | May 7th, 2004 07:24 PM |
filename in Excel | Are Skurdal | Worksheet Functions | 1 | May 3rd, 2004 02:19 PM |
Microsoft Excel - "Edit Cell Comment" abnormality | Dave Peterson | Worksheet Functions | 0 | March 9th, 2004 04:18 AM |