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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro that copies values from column A (from formula) to B (paste value) 1
Conditional Formatting: Highlight Cell that contains soonest Day 6
Help for formula. 4
Column of formulas with some cells containing data derived from thereformula's I would like to find 2
Count formula 5
Excel lookup across entire workbook 1
Populate cell with multiple non-blank text values 3
Last Modified By in a cell by user 3

Back
Top