Forum Discussion
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...
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 Functionuse as:
Thanks, Chris, I see that code.
I am a novice. I do not know how to create a macro, how to record it, save it, debug it, and then run it to do what it is supposed to do. Maybe this is just beyond me.
But thanks,
Noel
Learning more about Excel is not beyond anyone. https://support.office.com/en-us/article/create-custom-functions-in-excel-2f06c10b-3622-40d6-a1b2-b6748ae8231f provides you a good start.