Professor Excel

Comments 6

  1. Rayden

    Hi… i extract the comments but when i put in a new input on the comments .. its not auto generate even tho under options calculation is put under “automatic”

    • Henrik

      Hi Rayden,
      yes, that’s a problem. Usually it works if you hold Ctrl + Alt and press F9 on the keyboard to force a full calculation.
      Best regards,
      Henrik

  2. Mr. Owen Sneath

    Thanks!… your page helped me figure out how to get the comment out using Cells()… I was trying String=Cells().Comment… didn’t realize I needed to add .text… Saved me a lot – Thanks!

  3. Greg Stricker

    I need to extract comments to cells in Excel 2019. I downloaded Professor Excel, but cannot figure out how to use it for this. If I type =PROFEXCommentText(cell reference) in the cell where I want the comment text to appear, it tells me “there’s a problem with this formula”. What am I doing wrong?

    • Henrik Schiffner

      Hi Greg,
      I’ve sent you an e-mail. Let’s figure it out.
      Best regards,
      Henrik

  4. Bent Christensen

    Helle, and thanks for the formulas, its a great helt…

    I did encounter a problem, i have som notes that comes with som line changes, but when it comes out in the formula the cell just show one long line with the comment, is there any way to get the line changes from the comment or note in the cell also ?

Leave a comment

%d bloggers like this: