=A1&"TR"
and copy it across 450 row of data assuming col A holds the value
"Alex" wrote in message
...
I have about 450 values in a column that I want to ad TR to the end of it.
What formula would I use to accomplish this.

-thanks,