Add Same Text to All Cells in Column

S

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
 
V

Val

In what program? You could do it with text functions in Excel, but probably
not so easy if it's a table in Word.


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
 
V

Val

Well, then a simple approach is something like:

Where cell A1 contains some text, in B1 enter:
=CONCATENATE(A1,", my good friend")

You can extend this formula down as many rows as you have content you want
to add to.

If you want this new text to be the content of the A column cells, copy the
new result and Paste Special | Values to the A column locations.

Look at the Text functions for more interesting ways you can manipulate
text.

That's my quick and dirty solution, I'm sure someone may have a more elegant
approach.

Val


Thanks for your reply. It is in Excel.
Sol
 
S

S1L1Y1

Thank You Very Much for your help. I would very much appreciate if you can
explain in more detail.
Sol
 
Top