Excel: Appending Text in Cells Using Copy and Paste

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:

Select the cell to be copied from.
Select the text in the formula bar to be copied.
From the Edit menu, choose Copy.
Click the X to the left of the formula bar to leave the cell contents unchanged.
Select the cell to be copied to.
Click in the formula bar where the text is to be placed.
From the Edit menu, choose Paste. The copied text will be appended to the cell.
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.

KBCategory: kbother
KBSubcategory:
Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 31, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.