View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JP JP is offline
external usenet poster
 
Posts: 10
Default What is the Excel equivalent of the CELL function?

Thank you for your assistance, Bob.
Regards,
JP
"Bob Phillips" wrote in message
...
Lotus.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"JP" wrote in message
...
Thank you, but what is the explanation for the Remark on the function's

help
screen:
"Remark
The CELL function is provided for compatibility with other spreadsheet
programs"?
Normally this means there's another Excel-specific function, no?


"Bob Phillips" wrote in message
...
That is it.

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

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"JP" wrote in message
. ..
What is the Excel equivalent of the =CELL("filename",A1) function?
The
Excel 2003 help screen for this function states:



"Remark

The CELL function is provided for compatibility with other spreadsheet
programs."



I need a cell to display the filename and path.



Thank you,

JP