The function GETCOMMENT() is designed to get the comment of a cell.
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 (Calc) 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 are opened in Excel (LibreOffice Calc) .