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 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" wrote in message ... 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? |
All times are GMT +1. The time now is 10:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com