Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
The following articles are available for the 'Information Functions' topic. Click the article's title (shown in bold) to see the associated article.
Determining a Value of a Cell
Cells can store all sorts of information that can be formatted and displayed in a myriad of ways. If you want to quickly get to the value stored within the cell, you can use the N worksheet function.
Getting the Name of the Parent Workbook
If you need to insert into a cell the name of the workbook in which a worksheet is contained, you can use the CELL function. This tip explains the proper way to get the info you need.