append a string of text to all cells in a column?

[Lisa Hetherington]

Excel 2003
Is there a way to do this?
The cells that I want to append to all contaio plain text.

Thanks!

....Lisa

 

[Gord Dibben]

Lisa

Assuming column of text is A

In B1 enter =A1 & "textstring"

Double-click on the fill handle of B1 to copy down.


Gord Dibben MS Excel MVP

 

[Lisa Hetherington]

Thank you!!

....Lisa

Lisa

Assuming column of text is A

In B1 enter =A1 & "textstring"

Double-click on the fill handle of B1 to copy down.


Gord Dibben MS Excel MVP