Jan 06 2020 01:34 PM
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 to find an automated way to extract the content in each note (in order) so I do not have to open, copy, and paste each note's content individually. Can this be done?
Jan 06 2020 02:06 PM
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:
Jan 06 2020 04:29 PM
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
Jan 07 2020 07:47 AM
Learning more about Excel is not beyond anyone. https://support.office.com/en-us/article/create-custom-functions-in-excel-2f06c10b-3622-40d6-a1b2-b6... provides you a good start.
Jan 07 2020 08:47 AM
Aug 24 2021 05:53 PM
Aug 24 2021 10:12 PM
@EloyMendoza- it looks like https://professor-excel.com/excel-extract-comments-text-to-cell/ was updated for threaded comments. I have this version of Excel now so I can't test on an older version. My guess however is that you'll need to refresh the formula manually (enter edit mode and then enter; or similar manually) or I suppose you could do some VBA on cell change to refresh the calculation.
Aug 25 2021 05:37 AM
Jul 12 2023 11:58 PM