How to create formula for combining two cells as one cell

[Derrick.chang]

How to create formula for combining two cells as one
cell. All texts as formated as text.

Example:
1 2 3
A 123 456 =123456

 

[J.E. McGimpsey]

one way:

=A1 & A2

 

[wendy]

-----Original Message-----
How to create formula for combining two cells as one
cell. All texts as formated as text.

Example:
1 2 3
A 123 456 =123456

.

my understanding is you want the cell to now read 123456,
if this is correct. if 123 is in A1 and 456 is in b1, in
the cell that you want the combined totals to read use
=a1&b1