J
jgately
Is there a way in Excel to add new information to existing information to
cell(s)
cell(s)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
Perhaps post a few details about what you want added to what and where.
Or will you be happy with just "Yes", which is the answer to your specific
question.
Gord Dibben MS Excel MVP
Or will you be happy with just "Yes", which is the answer to your specific
question.
Gord Dibben MS Excel MVP
J
jgately
Sure we have a group on 3000 serial numbers that were enter by using the
last 7 number and not all 10 . We are trying to determine if there is a
function that will allow us to add 205 to all the exsiting cells
Exisiting need to be
CDB1002 205CDB1002
CDB1003 205CDB1003
CDB1004 205CDB1004
CDB1005 205CDB1005
CDB1006 205CDB1006
last 7 number and not all 10 . We are trying to determine if there is a
function that will allow us to add 205 to all the exsiting cells
Exisiting need to be
CDB1002 205CDB1002
CDB1003 205CDB1003
CDB1004 205CDB1004
CDB1005 205CDB1005
CDB1006 205CDB1006
G
Gord Dibben
Assuming the "existing" numbers are in Column A from A1:A3000
In B1 enter ="205" & A1
Double-click on the fill handle of B1 to copy down.
Fill handle is the little black lump on bottom right corner of B1. Hover the
cursor over this lump until it turns into a black cross.
D-click at that point.
OR drag the fill handle down as far as you wish.
When happy with the results, copy column B and in place, Edit>Paste
Special>Values>OK>Esc.
Now delete original column A.
Gord Dibben MS Excel MVP
In B1 enter ="205" & A1
Double-click on the fill handle of B1 to copy down.
Fill handle is the little black lump on bottom right corner of B1. Hover the
cursor over this lump until it turns into a black cross.
D-click at that point.
OR drag the fill handle down as far as you wish.
When happy with the results, copy column B and in place, Edit>Paste
Special>Values>OK>Esc.
Now delete original column A.
Gord Dibben MS Excel MVP
K
Kristoffer Andreas Berg
If the content of cell A1 is CDB1002, you can enter this formula in cell B1:
="205"&A1
With cell B1 selected you can Shift-click cell B3000 to select the whole
range. Now you can press Ctrl+D to copy the formula of the top cell of the
selection and paste it into the rest of the selected cells.
If you want to delete the cells with the original numbers (in column A), you
have to select the cells with the new numbers (in column B) and drag the
frame with the right mouse button to a new column, e.g. column C, and then
select "Copy Here as Values Only". Then delete columns A and B.
--
Kristoffer Andreas Berg
Programmer on a hobby basis
http://home.online.no/~gunnarab
="205"&A1
With cell B1 selected you can Shift-click cell B3000 to select the whole
range. Now you can press Ctrl+D to copy the formula of the top cell of the
selection and paste it into the rest of the selected cells.
If you want to delete the cells with the original numbers (in column A), you
have to select the cells with the new numbers (in column B) and drag the
frame with the right mouse button to a new column, e.g. column C, and then
select "Copy Here as Values Only". Then delete columns A and B.
--
Kristoffer Andreas Berg
Programmer on a hobby basis
http://home.online.no/~gunnarab
<SNIP>jgately said:Sure we have a group on 3000 serial numbers that were enter by using the
last 7 number and not all 10 . We are trying to determine if there is a
function that will allow us to add 205 to all the exsiting cells
Exisiting need to be
CDB1002 205CDB1002
CDB1003 205CDB1003
CDB1004 205CDB1004
J
jgately
Thank you everyone, it worked great.