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

L

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
 
G

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
 
L

Lisa Hetherington

Thank you!!

....Lisa
Gord Dibben said:
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
Click to expand...
 
Top