| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add filename in a cell
Hi Is there a formula I can write in a cell in a worksheet to get it to
return the filename? /Freddie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add filename in a cell
=CELL("filename",A1)
-- Gary's Student "FreddieP" wrote: Hi Is there a formula I can write in a cell in a worksheet to get it to return the filename? /Freddie |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add filename in a cell
See http://www.xldynamic.com/source/xld.xlFAQ0002.html
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "FreddieP" wrote in message ... Hi Is there a formula I can write in a cell in a worksheet to get it to return the filename? /Freddie |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add filename in a cell
=CELL("filename",A1)
it is give full path in a cell "FreddieP" wrote: Hi Is there a formula I can write in a cell in a worksheet to get it to return the filename? /Freddie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell References | Excel Discussion (Misc queries) | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Filename from a Cell | Excel Worksheet Functions | |||
| substitute the filename in a cell reference with a string in another cell. | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
