Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    Paste comment into a cell?

    I added a lot of comments (Insert / Comment) to a spreadsheet, and now I want to make a separate column that contains the comment text. It's a one-time conversion so it doesn't have to be fancy.

    I thought I could do Insert / EditComment, copy the comment text to the clipboard, and paste it into a cell. But every return in the comment text moves the pasting destination to the next cell.

    I tried Paste Special but it's no better.

    I figure I'm not the first one who's tried to do this so I might as well ask, eh?


  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Dublin, Ireland, Republic of
    Thanked 0 Times in 0 Posts

    Re: Paste comment into a cell?

    I suppose the comments are scattered without any particular order, but if you are prepared to use VBA you could use something like :

    Range("A1").Value = Range("D1").Comment.Text

    which will place the contens of a comment box attached to D1 in A1, including carriage returns. For best display you would need word wrap set to on.

    Hope that can help you.

    Andrew C

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts