Adding data to cells

[CharlesLWP]

Is there a command or function that allows adding data or words to a row of cells. For example:

If I have 100 different restaurants, one per cell, in Column A, and I wanted to add the word "Phoenix" the end of the current data in each of those cells in column A. Is there a way to do it that does not require "copy and paste" on each individual cell? Can I highlight that entire column and use some sort of command (like find/replace?), and insert something and not completely over write the current data. I just want to add to it.

[mrice]

Try typing

Please Login or Register  to view this content.

into cell B1 and then drag down using the fill handle (bottom right of the cell).

Then select all of column B, copy and (without changing the selection), paste values.