For the second reply, type =ProfessorExcelReturnCommentTextReply(B5, 2). In your Excel cell, enter =ProfessorExcelReturnCommentTextReply(B5,1) for the first reply. ProfessorExcelReturnCommentText = īecause the new comments can contain “conversations” with replies e.g., you can also extract the whole conversion. Function ProfessorExcelReturnCommentText(cell As Range) In your Excel cell, you enter =ProfessorExcelReturnCommentText(B5). ProfessorExcelReturnNoteText = įor the new comments, please use these lines of code and copy them to your VBA module.
Insert a new VBA module (please refer to this article and scroll down to “How to insert a new VBA module manually” if you need more information).In this case, just 3 lines of code could be the solution.įollow these steps for note texts (before: comments – the yellow once and the red cell corner). Extract comment text with a simple VBA code.Īs so often with rather tricky problems in Excel, VBA can help.
