Insert text to the beginning of every Cell in a Column

I'm trying to find a way to insert text in to every Cell in a specific Column.

e.g. Column C has 50 rows: I need to insert 0049 to the beginning of every Cell.

I didn't had any luck finding/creating a formula for this.

Help is much appreciated.

1 Answer

Create a blank Column (D) and use "CONCATENATE":

=CONCATENATE("0049",C1)

Drag that down for each adjacent cell in Column C and it will add 0049 as a prefix.