consildation

  • Thread starter Thread starter Ken F
  • Start date Start date
K

Ken F

I want to move the text or numbers that are in two
different cells and merge them into on cell.

Example One cell has aaa in it and another cell has bbb
in it. I want to move both into one cell. It would look
likd this aaabbb or aaa bbb.

I am using Excel 2000

Thanks
 
go to the Fx(function button)ask for text then request
concatenate. Basically the equation looks like this in a
new cell that you would create: =CONCATENATE(A1,B1)then
you can copy and paste to the entire doc and edit your
other cells if you need to. Hope this helps.
 
additionally in the equation should you wish to place a
space in between the aaa bbb. in the equation it should
look like this: =CONCATENATE(A1," ",B1) Make sure that
you place a space in between the quotation marks.
 
Back
Top