Add Same Text to All Cells in Column
 

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

Add Same Text to All Cells in Column
 

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

On May 16, 3:52*pm, "S1L1Y1" wrote:
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

Add Same Text to All Cells in Column
 

Thank You Very Much for your help. I would very much appreciate if you can
explain in more detail.
Sol
"Pete_UK" wrote in message
...
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

On May 16, 3:52 pm, "S1L1Y1" wrote:
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