Combining Info Fom Cells

[JR]

Hello,

Need some help. Not sure of how to proceed. I need to know how to combine
cell info.

Example:

Cell 1: 123
Cell 2: 345

Output in cell 3 would be 123456

Thanks Jr

 

[Max]

If you have col A = Cell 1's, col B = Cell 2's

Put in C1: = A1&B1

Copy C1 down col C

 

[Kieran]

if cell 1 is A1 and cell 2 is a2 then
=A1&A2 will do the business.

 

[Gord Dibben]

JR

Assume A1 and B1 contain the numbers.

In C1 enter =A1&B1

Note: C1 will be Text and cannot be used for calculations.

To change it back to a number, copy a blank cell and select C1 then paste
special>add>OK>Esc

Get rid of the formula in C1 by Copy>Paste Special(in place)>Values>OK(you can
skip this step if you want the formula to stay)

Gord Dibben Excel MVP

 

[Norman Harker]

Hi!

Or in one operation you can get the number 123456:

=VALUE(A1&A2)

or:

=--(A1&A2)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

JR

Assume A1 and B1 contain the numbers.

In C1 enter =A1&B1

Note: C1 will be Text and cannot be used for calculations.

To change it back to a number, copy a blank cell and select C1 then paste
special>add>OK>Esc

Get rid of the formula in C1 by Copy>Paste Special(in place)>Values>OK(you can
skip this step if you want the formula to stay)

Gord Dibben Excel MVP

 

[Dawn Killick]

Hello,

Need some help. Not sure of how to proceed. I need to know how to combine
cell info.

Example:

Cell 1: 123
Cell 2: 345

Output in cell 3 would be 123456

Thanks Jr

In cell 3 enter =concatenate(cell1,cell2)

 

[2rrs]

This seems to work also; without the extra step:

=(A1&B1)*1

 

[Gord Dibben]

Yes, it does eliminate the extra step.

The things we learn!!

Thanks, Gord