help me is it possible to add to multiple cells without changing t

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to add "ca" in the begining of all 3000 cells on my worksheet without
changing the data that is in the cells already is this possible without
editing all 3000 cell indiv please help
 
Try on a spare copy ..

Assuming data running in A1 down

In B1:
=IF(A1="","","ca"&A1)
Copy B1 down to the last row of data in col A

Then kill the formulas in col B with an in-place: Copy > Paste special >
Check "Values" > OK. Then delete col A
 
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

Assigning a Worksheet Name to a Cell 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Can I use an "=" in Excel 2007 cell without making it a function? 2
Formula changes to answer within the cell or some variation 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
want to track time while paste value in multiple column of same roe 1
Is it possible to specify multiple condition with SUMIF? 1
How:Add New Worksheet that copies the cell of the previous sheet 1

Back
Top