Extract both Cell and Comment

Hi there

I'm trying to extract both value and comment of a cell to another cell.

For example, I can put "=A1" in B1 to get A1's value in B1, but A1 also has a comment, how do I get this comment as well? Note that I actually use formulas to extract A1 to B1 but I also want to extract A1's comment, so basically make B1 a carbon copy of A1.

I looked around on internet, there is VBA code to extract the comment's value to a cell, that's not what I want.

Thanks for your help.