Auto formatting cells

L

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.
 
B

bjoeylouie

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

Copy down to B100 (last cell) to finish
 
Top