Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the Excel equivalent of the CELL function?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the Excel equivalent of the CELL function?
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the Excel equivalent of the CELL function?
=cell("filename",a1)
is the equivalent in Excel <bg JP wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the Excel equivalent of the CELL function?
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the Excel equivalent of the CELL function?
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? "Dave Peterson" wrote in message ... =cell("filename",a1) is the equivalent in Excel <bg JP wrote: 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 -- Dave Peterson |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the Excel equivalent of the CELL function?
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the Excel equivalent of the CELL function?
If you look at the =Cell() function in Excel's help, you'll see that the first
argument can be lots of things. If I were designing a spreadsheet program from scratch, I'm not sure I'd ever think about including: =CELL("contents",A1) But if I had to take in consideration lots of other spreadsheet programs (and wanted to have those users become my customers), I'd make sure I'd include stuff that didn't make obvious sense to me. I'd do my best to make the transition as easy as possible. JP wrote: 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? "Dave Peterson" wrote in message ... =cell("filename",a1) is the equivalent in Excel <bg JP wrote: 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 -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the Excel equivalent of the CELL function?
Thanks Dave, for that explanation.
Best wishes, JP "Dave Peterson" wrote in message ... If you look at the =Cell() function in Excel's help, you'll see that the first argument can be lots of things. If I were designing a spreadsheet program from scratch, I'm not sure I'd ever think about including: =CELL("contents",A1) But if I had to take in consideration lots of other spreadsheet programs (and wanted to have those users become my customers), I'd make sure I'd include stuff that didn't make obvious sense to me. I'd do my best to make the transition as easy as possible. JP wrote: 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? "Dave Peterson" wrote in message ... =cell("filename",a1) is the equivalent in Excel <bg JP wrote: 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 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pethow do i insert a Yes/No function into a cell in Excel? | Excel Discussion (Misc queries) | |||
Wrap text ceases to function in Excel if cell exceeds 9 lines | Excel Worksheet Functions | |||
Need Excel Function that will return # of char in preceding cell | Excel Discussion (Misc queries) | |||
Need Excel Function that will return # of char in preceding cell | Excel Worksheet Functions | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) |