copy, insert and add digits

R

Ronco Bill

have a large spreadsheet that we need to copy the content of one column into
another column. we also need to add in three leading digits into the new
column???
 
S

SVC

If the three leading digits are the same, and your original numbers are in
column A, in cell B1 type ="***"&A1. The asterisks should be replaced by
your three leading digits. Now copy the formula down as far as needed. The
Copy the new range in column B and paste it back via Edit > Paste Special,
Value (to get rid of the formula).
 
Top