Microsoft KB Archive/32548

{| = Excel: Appending Text in Cells Using Copy and Paste =
 * width="100%"|

Last reviewed: October 31, 1994

Article ID: Q32548

SUMMARY
In Microsoft Excel, to append text from one cell to text in another cell using Copy and Paste, do the following:


 * 1) Select the cell to be copied from.
 * 2) Select the text in the formula bar to be copied.
 * 3) From the Edit menu, choose Copy.
 * 4) Click the X to the left of the formula bar to leave the cell contents unchanged.
 * 5) Select the cell to be copied to.
 * 6) Click in the formula bar where the text is to be placed.
 * 7) From the Edit menu, choose Paste. The copied text will be appended to the cell.
 * 8) Press RETURN to enter the new text into the cell.

Clicking on a cell and choosing Copy without anything selected in the formula bar copies the entire cell, including cell attributes other than the contents. This additional information cannot be appended to a cell by pasting into the formula bar, so the Paste command will be gray when the formula bar is active.
 * }