If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I translate a comment to text in a cell?
A cell has existing text in it and it has a comment attached to it. I'd like
to append the comment to the end to the existing text in the cell. Has anyone done this already? Is it possible without going into each and every comment? Thanks, Chris |
#2
|
|||
|
|||
ASAP utilities has a UDF formula called "ASAPGetComment()". If you install
this utility (which I highly and impartially recomend), you could use this formula to concatenate the two together. http://www.asap-utilities.com "DFIChris" wrote: A cell has existing text in it and it has a comment attached to it. I'd like to append the comment to the end to the existing text in the cell. Has anyone done this already? Is it possible without going into each and every comment? Thanks, Chris |
#3
|
|||
|
|||
You could use a little macro:
Option Explicit Sub testme() Dim myCommentCells As Range Dim myCell As Range Set myCommentCells = Nothing On Error Resume Next Set myCommentCells = Intersect(Selection, _ Selection.Cells.SpecialCells(xlCellTypeComments)) On Error GoTo 0 If myCommentCells Is Nothing Then MsgBox "Please Select a range with comments and try again!" Exit Sub End If For Each myCell In myCommentCells.Cells With myCell .Value = .Value & " " & .Comment.Text End With Next myCell End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm DFIChris wrote: A cell has existing text in it and it has a comment attached to it. I'd like to append the comment to the end to the existing text in the cell. Has anyone done this already? Is it possible without going into each and every comment? Thanks, Chris -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Ideas On Producing Envelopes & Labels For Data | RNUSZ@OKDPS | Setting Up & Running Reports | 0 | April 28th, 2005 03:22 PM |
Query for 'confirmation' | rogge | Running & Setting Up Queries | 8 | April 19th, 2005 03:26 PM |
Need Subforms? | AccessRookie | Using Forms | 7 | April 8th, 2005 09:30 AM |
Concatenatd fields in a query for a searching form | Marc | Running & Setting Up Queries | 8 | October 19th, 2004 08:49 PM |
Text not fitting in a cell | Arvi Laanemets | Worksheet Functions | 1 | May 1st, 2004 09:34 AM |