How to create formula for combining two cells as one cell

  • Thread starter Thread starter Derrick.chang
  • Start date Start date
D

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

.
Click to expand...
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
 
Back
Top