Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy, insert and add digits
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??? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy, insert and add digits
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). "Ronco Bill" wrote: 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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|