Bringing data together

  • Thread starter Daniel Louwrens
  • 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
 
D

Dan E

Daniel,

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

Daan E
 
J

justin

-----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.
 
W

Wim Ruepert

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
 
Top