I have a 75x800 cell spreadsheet that has comments attached to many cells. I need to copy the contents of those comments to new cells at the end of the row they appear in:
- Some rows will have no cells with comments and some will have up to five cells with comments.
- I need to know what cell the comment originally came from when I am reading the comment in the newly created cell: Ideally, the new cell would have the original cell number followed by the comment, e.g. New Cell C76 would contain the comments attached to cell C4 and start with "From C4: ..."
- The comments then need to be deleted from the original cells.

I am using Excel 2003 on an XP-Pro machine.

Thanks very much in advance for all of your time and assistance!

Regards,

Guy


p.s. And if you're REALLY bored and have nothing else to do except to solve my problems , is there is a way to color code the cells so both the original cell and the new comment cell are the same color?