CELL
Returns information about the formatting, location, or contents of a cell.
InformationDesktop OnlyInformation & Auditing
What it does
Returns metadata about a cell such as format, width, or file path.
Syntax
CELL(info_type, [reference])
Arguments
info_type(text) — Type of info (e.g., "address", "filename", "format").reference(reference) — Cell to check.
Examples
Get File Path
Returns the full path and filename.
FORMULA
=CELL("filename", A1)RESULT
C:\Docs\[Book1.xlsx]Sheet1
SAMPLE DATA
| A | |
|---|---|
| 1 | Data |
| 2 | (Saved File) |