Excel: Move cell contents to comment

microsoft excelmicrosoft-excel-2007

I'm using Excel 2007.

I have a list of items and wish to take the information in the cells of one column and move it into comments for the cells in that column.

Is there a way to do this that doesn't involve manually cutting the cell content then creating a comment and pasting the text in?

Best Answer

The following VBA code will move the text values of the selected cells into the comments. It will only work if there arent any existing commnets

Sub Test()
    For i = 1 To Selection.Rows.Count
        For j = 1 To Selection.Columns.Count
            Selection.Cells(i, j).AddComment (Selection.Cells(i, j).Text)
        Next
    Next
End Sub

Related Solutions

Excel – copy excel cell copies carriage return also

I believe you'd want the carriage return if you were copying more than one cell, which is probably why it's being included.

But if you're copying one at a time, you can copy from the formula bar instead of from the cell then you won't get the carriage return.

If you have a lot of cells to copy, you might want to create a simple VBA script to push the contents of the selected cell into the clipboard (then assign that to a hotkey).

Edit:

Example macro:

Sub CopyActiveCell()
    Dim objData As MSForms.DataObject
    Set objData = New MSForms.DataObject
    objData.SetText ActiveCell.Value
    objData.PutInClipboard
End Sub

Note that for that to work you need to add a reference to Microsoft Forms 2.0 Object Library (via Tools | References). If you're copying many values, you could make it even simpler by adding creating the sub in the Sheet1 module as

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

instead of

Sub CopyActiveCell()

That will automatically copy the cell value whenever you click once on a cell to select it.

Excel – Microsoft Excel 2007 – Cannot Fit All Text Into Cell

There are two points here; containing and displaying.

Per Microsoft 32,767 characters is the max a cell can contain. So yes you can fit 10,110 characters in the cell.

As allready discussed in other answers, no you can not display that many characters in a fashion that will be readable.

Reference http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx

Best Answer

Related Solutions

Excel – copy excel cell copies carriage return also

Excel – Microsoft Excel 2007 – Cannot Fit All Text Into Cell

Related Question