Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
print
pls, help me about, how me can to print files name with worksheet without to
come in set up/header n footer . iam just forget to typing it n iam remember use sign is $ files.....( bla...bla..). tq. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
print
pls, help me about, how me can to print files name with worksheet
without to come in set up/header n footer . iam just forget to typing it n iam remember use sign is $ files.....( bla...bla..). tq. Previous people's postings have suggested the formulas below to put the file name in an Excel cell. They work only after the file has been saved. In each case, combine the two lines into a single formula. Full path: =SUBSTITUTE(LEFT(CELL("filename",a1),FIND("]", CELL("filename",a1))-1),"[","") Just the file name: =MID(CELL("filename",a1),SEARCH("[",CELL("filename",a1))+1,SEARCH("]", CELL("filename",a1))-SEARCH("[",CELL("filename",a1))-1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
How to format the extension less file to print with Dos's Print Command | Excel Discussion (Misc queries) | |||
cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions |