CELLCOMMENT

Returns the cell comment of a cell. For a range with more than one cell, it returns the cell comment of the first cell in the range.

Syntax

CELLCOMMENT(range_input)

range_input - is the range (cell) which you want to find out the cell comment.

Example

(See above figure) If cell I19 contains a cell comment “exceptional item”, the formula:
=CELLCOMMENT(I19) returns the answer “exceptional item”.