Move Cell Data to Imbedded Comment

[Hudson]

Is there a formula that will move text comments into an existing cell with data as an imbedded comment? Perferably without using a macro.

Ideally, looking for a formula that would inbed the data in Column A as a comment in Column B

If macro is the only option, if someone could walk me through the process of using a macro, that would be great - I am not familiar with using macros

[Jakobshavn]

Here is a macro-based solution. Open the file. Enable macros. Touch ALT-F8
Touch Run

[Hudson]

Thanks - How would I set this up with another file?

[Jakobshavn]

Here is the macro itself:

Sub InsertComments()
For Each r In Intersect(Range("A:A"), ActiveSheet.UsedRange)
    If IsEmpty(r) Then
    Else
        With r.Offset(0, 1)
            .AddComment
            .Comment.Visible = True
            .Comment.Text Text:=r.Text
        End With
    End If
Next
End Sub

Macros are very easy to install and use:

1. ALT-F11 brings up the VBE window
2. ALT-I

ALT-M opens a fresh module

3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To remove the macro:

1. bring up the VBE window as above
2. clear the code out
3. close the VBE window

To use the macro from Excel:

1. ALT-F8
2. Select the macro
3. Touch RUN

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Macros must be enabled for this to work!