Can Comments be automatically converted to text cell values?

I have a large number of cells with Comments. I'd like to basically convert
the Comments to text values in cells (in a column right next to the cells
that have the Comments). Is there a function or other tool for doing this in
Excel 2000?

Hi!

Yes.
I use the lazy way which is the collection of tools from Bastien Mensink at www.asap-utilities.com. Free download.

One of them specifically takes comments and puts them in the next-right cell.

Alf

Hi Tom,
You can use a User Defined Function to do that.

Cell Comments
http://www.mvps.org/dmcritchie/excel....htm#mycomment

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"tomdog61" <tomdog61@discussions.microsoft.com> wrote in message news:06527A5B-1558-424A-B76A-311996DDA525@microsoft.com...
> I have a large number of cells with Comments. I'd like to basically convert
> the Comments to text values in cells (in a column right next to the cells
> that have the Comments). Is there a function or other tool for doing this in
> Excel 2000?