Appending text to every cell in Excel spreadsheet

I needed to add same text to the end of every cell in one column:

• All your data is in column A (beginning at row 1).
• In column B, row 1, enter =A1&"THIS_TEXT_APPENDED"
• This will make cell B1 equal A1 with THIS_TEXT_APPENDED
• Now select cell B1 and drag from the bottom right of cell down through all your rows (this copies the formula and uses the corresponding column A value.

http://stackoverflow.com/questions/3179513/how-to-append-same-text-in-every-cell-in-ms-excel