Is there a way in Excel to add new information to existing information to
cell(s)

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


On Sat, 19 Aug 2006 10:39:01 -0700, jgately
wrote:

Is there a way in Excel to add new information to existing information to
cell(s)

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




"Gord Dibben" wrote:

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


On Sat, 19 Aug 2006 10:39:01 -0700, jgately
wrote:

Is there a way in Excel to add new information to existing information to
cell(s)

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, EditPaste
SpecialValuesOKEsc.

Now delete original column A.


Gord Dibben MS Excel MVP


On Sat, 19 Aug 2006 11:52:05 -0700, jgately
wrote:

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




"Gord Dibben" wrote:

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


On Sat, 19 Aug 2006 10:39:01 -0700, jgately
wrote:

Is there a way in Excel to add new information to existing information to
cell(s)

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


"jgately" wrote:

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
<SNIP

Thank you everyone, it worked great.

"jgately" wrote:

Is there a way in Excel to add new information to existing information to
cell(s)