Bringing data together

  • Thread starter Thread starter Daniel Louwrens
  • Start date Start date
D

Daniel Louwrens

I have two columns of numbers and I want to join these in a third column,
not add them up but combine them.
For example 1st cell reads 15, the adjacent cell reads 203 and I want the
third cell across to combine these to 15203.

Is there some way to automate this in Excel 2000 SP3

please advise

Daniel
 
Daniel,

If you want it to be text use
=E30 & F30
If you want it to be a number
=--(E30 & F30)

Daan E
 
-----Original Message-----
I have two columns of numbers and I want to join these in a third column,
not add them up but combine them.
For example 1st cell reads 15, the adjacent cell reads 203 and I want the
third cell across to combine these to 15203.

Is there some way to automate this in Excel 2000 SP3

please advise

Daniel
Click to expand...

=VALUE(CONCATENATE(H13,I13))
would do the trick where H13 and I13 were the cells to
join together.You can concatenate the values in up to 30
cells. CONCATENATE turns numeric data into text first.
 
You can usse the "Concatenate" option to combine the data of the two collums
in a third collumn
Then just copy and paste the values of the third collums.

In your example:

Cell A1 = 15
Cell B1 = 203

Enter in Cell D1: =concatenate(a1,b1)

krgds
Wim
 
Back
Top