| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to type a text in a cell, but I want that text to represen. | Excel Discussion (Misc queries) | |||
| Remove the apostrophe (') in Excel cell text values | Excel Discussion (Misc queries) | |||
| Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Hide text that doesn't fit in the cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
