Copy a "Comment Text" in to "Cell T
Solved/Closed
Deepak
-
Feb 22, 2010 at 06:55 AM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Feb 23, 2010 at 04:35 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Feb 23, 2010 at 04:35 PM
Related:
- Copy a "Comment Text" in to "Cell T
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- How to download a google doc with comments - Guide
- Count if cell contains number - Excel Forum
- We limit how often you can post, comment or do other things in a given amount of time in order to help protect the community from spam. you can try again later. ✓ - Facebook Forum
- Which key is used to make multiple line in a single cell - Guide
2 responses
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Feb 23, 2010 at 04:35 PM
Feb 23, 2010 at 04:35 PM
Hi,
You can create a personalized macro function :
And after if you want to copy the comment of the cell sheet1 A1 in to cell sheet2 B2, you can do it by using this new function. The formula in sheet2 B2 will be :
=CopyComment(Sheet1!B2)
Best regards
You can create a personalized macro function :
Function CopyComment(cel As Range)
CopyComment = cel.Comment.text
End Function
And after if you want to copy the comment of the cell sheet1 A1 in to cell sheet2 B2, you can do it by using this new function. The formula in sheet2 B2 will be :
=CopyComment(Sheet1!B2)
Best regards
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 22, 2010 at 07:13 AM
Feb 22, 2010 at 07:13 AM
I think you are trying to say that you want to copy a comment of a cell and paste it as a value in another cell. I dont think there is a formula to do it. You may to create your formula
