Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert From Comment to Cell Content
My admin put data into comments instead of a seperate column. How can I
move/copy/convert that data from a comment to the contents of a cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert From Comment to Cell Content
Try this UDF (User Defined function). From workbook launch VBE using Alt+F11.
From menu Insert a Module and paste the below function.Close and get back to workbook and try the below formula. =GetComments(A1) Function GetComments(rngTemp As Range) If Not rngTemp.Comment Is Nothing Then GetComments = rngTemp.Comment.Text End If End Function The formula wil have to be recalculated when you change the comments; -- Jacob "Sue" wrote: My admin put data into comments instead of a seperate column. How can I move/copy/convert that data from a comment to the contents of a cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting cell content into comment | Excel Discussion (Misc queries) | |||
Converting cell content into comment | Excel Discussion (Misc queries) | |||
copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
Can Comment in a cell be changed as the content in another cell ?? | Excel Discussion (Misc queries) | |||
How do I copy the cell-content plus its comment to another cell ? | Excel Worksheet Functions |