Excel: Extract Cell Comments WITH FORMATTING into Cell Text

I can't figure this out for the life of me... even manually in Excel, so that I can sick "Macro Recorder" on it.

Q: How can you copy or get the content ("custom formatted text") of an Excel (2007) cell comment out, and paste it into a cell as a cell's content (again, "formatted text") ?
Solutions accepted manually or programmatically.

Ultimately, I need to turn this into VBA. Right not I'm using something similar to the "showcomments" function here:
http://www.contextures.com/xlcomments03.html

I have figured out how to copy and paste a whole comment as in...

Dim rngSource As Range
Dim rngTarget As Range
Set rngSource = ...
rngSource.Copy
Set rngTarget = ...
rngTarget.PasteSpecial Paste:=xlPasteComments
 

...but not how to get the comment (and it's formatting) out.

Any ideas?