Insert active file name in the cell

[Hoang Han]

How can I display the File name into a cell (excluded
extension)

Ex: source is C:\DATA\Q0978.XLS
Destination: Q0978

 

[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.

 

[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

 

[Hoang Han]

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))

+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

How can I display the File name into a cell (excluded
extension)

Ex: source is C:\DATA\Q0978.XLS
Destination: Q0978

.