Excel is generally used to get calculations in a specific order. User with large amounts of data would need formulas to use Excel as efficiently as possible. Sometimes a user may find it difficult to copy a Comment Text into a cell text. A personalized function can be created in Excel by using a particular formula. The user can instantly copy the available comment in the first cell sheet. There are various cell sheets where an individual can copy a large amount of data.

## Issue

**I can't find the formula on how to copy a "Comment Text" into the "Cell Text" in another sheet. **

## Solution

You can create a personalized macro function:

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:

## Note

Thanks to aquarelle for this tip on the forum.
## Related

You can create a personalized macro function:

Function CopyComment(cel As Range) CopyComment = cel.Comment.text End Function

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!A1)

Thanks to aquarelle for this tip on the forum.

- Excel - copy a "Comment Text" into "Cell T"
- Copy a "Comment Text" in to "Cell T (Solved) » Forum - Office software
- Excel - Copy data next to a cell and paste it below » How-To - Excel
- Excel - Copy data into next empty cell in new sheet » How-To - Excel
- Copy data onto sheet only if cell has text [Solved] (Solved) » Forum - Excel
- Transfer Data Between Excel Spreadsheets » How-To - Excel

Published by aakai1056.
Latest update on March 17, 2012 at 08:44 AM by Virginia Parsons.