Automatically add something to cells

[SavvyEd]

I need to add "A" to the end of IDs already filled out in a column.

For example, if I have a column with


1234
2345
5678
etc

I need to make them
1234A
2345A
5678A
etc

Is there a quick way to do this? I have thousands of rows.

[SavvyEd]

I actually just figured it out, so I'll post the solution in case anyone else needs it.

I inserted a new column and used this formula:
=A1&"A"

[macropod]

As simpler way, that can be applied to the data cells without modifying the workbook content, is to apply the following custom number format to the cells:
#\A