H Hoang Han Dec 3, 2003 #1 How can I display the File name into a cell (excluded extension) Ex: source is C:\DATA\Q0978.XLS Destination: Q0978
How can I display the File name into a cell (excluded extension) Ex: source is C:\DATA\Q0978.XLS Destination: Q0978
M MS Dec 3, 2003 #2 You can use the Hyperlink function in Excel. Type the text that you want to show in the cell. Q0978 On the menu bar, click Insert Hyperlink then find the source file C:\DATA\Q0978.XLS click OK You have your hyperlink! You can change the displayed text by using right click, then edit hyperlink.
You can use the Hyperlink function in Excel. Type the text that you want to show in the cell. Q0978 On the menu bar, click Insert Hyperlink then find the source file C:\DATA\Q0978.XLS click OK You have your hyperlink! You can change the displayed text by using right click, then edit hyperlink.
P Peo Sjoblom Dec 3, 2003 #3 One way =LEFT(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255),FIND(".", MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255))-1) that is actually the formula, don't get confused by "filename" the above will return the file name minus the extension
One way =LEFT(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255),FIND(".", MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255))-1) that is actually the formula, don't get confused by "filename" the above will return the file name minus the extension
H Hoang Han Dec 3, 2003 #4 I tried it, It very very good Thanks -----Original Message----- One way =LEFT(MID(CELL("filename",A1),FIND("[",CELL ("filename",A1))+1,255),FIND(".", MID(CELL("filename",A1),FIND("[",CELL("filename",A1)) Click to expand... +1,255))-1) that is actually the formula, don't get confused by "filename" the above will return the file name minus the extension -- Regards, Peo Sjoblom Hoang Han said: How can I display the File name into a cell (excluded extension) Ex: source is C:\DATA\Q0978.XLS Destination: Q0978 Click to expand... . Click to expand...
I tried it, It very very good Thanks -----Original Message----- One way =LEFT(MID(CELL("filename",A1),FIND("[",CELL ("filename",A1))+1,255),FIND(".", MID(CELL("filename",A1),FIND("[",CELL("filename",A1)) Click to expand... +1,255))-1) that is actually the formula, don't get confused by "filename" the above will return the file name minus the extension -- Regards, Peo Sjoblom Hoang Han said: How can I display the File name into a cell (excluded extension) Ex: source is C:\DATA\Q0978.XLS Destination: Q0978 Click to expand... . Click to expand...
