File name and path formula in Excel 2003

[Graeme]

I used to use a formula that would give the worksheet name, file name and
file path in an excel worksheet. I think the last time I used it might have
been in Office 97.

I am trying to do it again in Excel 2003 but can't seem to find the function.

Can anyone advise what it is or is it something that was dropped between
versions for Excel?

I know Page Setup / Footer is an alternative but I was trying avoid it.

Thanks

 

[Gary''s Student]

=CELL("filename",A1)

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)