H
Hoang Han
How can I display the File name into a cell (excluded
extension)
Ex: source is C:\DATA\Q0978.XLS
Destination: Q0978
extension)
Ex: source is C:\DATA\Q0978.XLS
Destination: Q0978
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
MS
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.
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
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
=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
I tried it, It very very good
Thanks
Thanks
-----Original Message-----
One way
=LEFT(MID(CELL("filename",A1),FIND("[",CELL ("filename",A1))+1,255),FIND(".",+1,255))-1)MID(CELL("filename",A1),FIND("[",CELL("filename",A1))
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
.