Forum Discussion

Noel_Sherry's avatar
Noel_Sherry
Copper Contributor
Jan 06, 2020

Extracting content from all cell notes on Excel sheet

I have used an Excel Sheet to record blood pressure readings for my health, and I have put a daily journal remark in a separate cell note for each day. I have hundreds of these notes, and I am trying...
excel
Macros and VBA
ChrisMendoza's avatar
ChrisMendoza
Iron Contributor
Jan 06, 2020

Noel_Sherry -

You can use the example custom function found at https://professor-excel.com/excel-extract-comments-text-to-cell/.

Function ReturnNoteText(cell As Range)
    ReturnNoteText = cell.Comment.Text
End Function

 use as: