filename in a cell

[Danny Wilsher]

i can put the entire file name in a cell with =cell("filename") , but i would like to only have a portion of it in the cell. i save the job number i am working on in a folder and the complete path of the folder is displayed. i only want the job number to appear in the cell. thanks for any suggestions!!!!! danny.....

 

[Chris Davison]

Hi Nate,

one of the first things I usually do on a new sheet is add =cell("filename",a1) so I can find it later, just discipline, I guess. However, I often find myself deleting row 1 or column A a few times throughout the design which then gives an #N/A in this reference. Pain ? oh yes. Just a tip, but now whenever I use it, I use =cell("filename",aa9999).

Just thought I'd share

 

[NateO]

Good point Chris, any cell reference on the sheet [without "sheetname"!] in question will "ground" any of the "filename" formulae in question. T'is why the a1 reference need not be an absolute value (i.e., $a$1)

Cheers, Nate
This message was edited by NateO on 2002-02-27 19:17

 

[NateO]

Another way (fyi):

= LEFT(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1),LEN(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1))-4)


Cheers, Nate