Formula for copying comments

[GunNam]

Is there a way to copy/get the "comments" of a cell using an excel formula?
i.e. if A1 contains a comment, copy that comment to B1?

I am not looking for the VBA way to pull the comments.

Thank you!

 

[Domski]

Pretty sure there isn't without VBA.

Dom

 

[DonkeyOte]

GunNam, welcome to the Board.

If you x-post the same question on multiple forums please disclose all relevant links on each forum.

 

[GunNam]

GunNam, welcome to the Board.

If you x-post the same question on multiple forums please disclose all relevant links on each forum.

Hi DonkyOte, thanks for the welcome.

I am merely trying to increase visibility by posting on 2 forums. Especially so because my question was misunderstood and then closed without a single reply from myself (Previous post on the other forum). In addition, some forums don't like links to other forums.

Anyhow, here is the link to my question on the other forum if it helps. This thread links the previous thread as well:
http://www.excelforum.com/excel-programming/747445-excel-formula-for-comments.html

 

[JimM]

Can you not just copy cell A1 and

Paste Special > Comments ?

HTH

Jim


Ahhh just realised you probably want the actual wording to appear in cell B1 - in which case the above obviously won't work !

 

[JimM]

DonkeyOte

Out of interest, if someone posts on more than one forum why do you want the links etc posted ?

Cheers

Jim

 

[GunNam]

Can you not just copy cell A1 and

Paste Special > Comments ?

HTH

Jim

Hey Jim,

Yes, you can, but I'm specifically looking for a formula that would do it. Thanks for the response!

 

[GunNam]

GunNam, welcome to the Board.

If you x-post the same question on multiple forums please disclose all relevant links on each forum.

Hey before you point me to the link... someone brought this to my attention on my previous post on the other forum. I know now, and it shouldn't happen in the future.

http://www.excelguru.ca/node/7