View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tim Tim is offline
external usenet poster
 
Posts: 408
Default Converting comments to data


Here is a very nice sample workbook:
http://www.contextures.on.ca/CommentsNumberPrint.zip

Tim


"glarosa" wrote:

Hi There,

I have a basic spreadsheet set up and in one particular column, each cell
has a comment attached. Is there some way that I create a new column and copy
each of those comments into the cells so that they become part of the data in
the spreadsheet? I don't want to cut and paste each individually as there are
hundreds of cells but do them on one go. Is this possible?

Thanks in advance for your help.

--
Cheers

GLR