The GETCOMMENT() function is designed to get a cell comment.
You can also use a ready-made tool "Copy comment to cell" , which automatically copies the comment for the selected cells.
=GETCOMMENT(Cell)
The GETCOMMENT() function is easy to use. You just need to specify the cell with the comment and Excel will automatically return the text of her comment:
=GETCOMMENT(Cell)
We will have the following result:
This example uses the following values:
You can use the function GETCOMMENT() by installing the extension
After that, this function will be available in all files that will be opened in Excel .