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...
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.
Chris, Thanks for your quick answer.