Add Same Text to All Cells in Column

[S1L1Y1]

I would like to ask if there is a way that I can add the same text to
existing text in all cells in column. Each cell has deferent text. I have
office XP.
Sol

 

[Pete_UK]

Assuming your existing text is in column A, then put this formula in a
helper column:

=A1 & "extra_text"

and copy this down as far as you need it.

If you want it back in the original column, then highlight the column
with the formula in, click <copy>, then Edit | Paste Special | Values
(check) | OK then <Esc>. Now you can copy the helper column to
overwrite the data in column A, and then delete the helper column.

Hope this helps.

Pete

 

[S1L1Y1]

Thank You Very Much for your help. I would very much appreciate if you can
explain in more detail.
Sol
Assuming your existing text is in column A, then put this formula in a
helper column:

=A1 & "extra_text"

and copy this down as far as you need it.

If you want it back in the original column, then highlight the column
with the formula in, click <copy>, then Edit | Paste Special | Values
(check) | OK then <Esc>. Now you can copy the helper column to
overwrite the data in column A, and then delete the helper column.

Hope this helps.

Pete