View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
jgately jgately is offline
external usenet poster
 
Posts: 3
Default can u add common info to a cells in a column with out doing @

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)