Auto formatting cells

[leeraffey]

I have a list in cells A1:A100

I would like to create a new column that has the text "CA:" before each text in column A. Is there a formula for this? Thanks in advance.

[bjoeylouie]

Try this in the target column (column B)
="CA:" & A1

Copy down to B100 (last cell) to finish