how can i copy comments into a cell so that it appears as text

[billwest]

Is there an automated way to copy comments into cells? Or reformat the cells
so that the comments become the cell contents?

 

[Frank Kabel]

Hi
no, this would require VBA. See:
http://www.contextures.com/xlcomments03.html#CopyToWord