Auto formatting cells

  • Thread starter Thread starter leeraffey
  • Start date Start date
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.
 
Try this in the target column (column B)
="CA:" & A1

Copy down to B100 (last cell) to finish
 
Back
Top