Merge cell values
 

How do I merge the values in three cells into one. The example is I have
three cells

Cell 1 cell 2 Cell 3
123 456 789

I want to have one cell that merges these values into 123456789

Any ideas if this can be done?

cell 4
=A1&B1&C1

"Mpls501sMan" wrote:

How do I merge the values in three cells into one. The example is I have
three cells

Cell 1 cell 2 Cell 3
123 456 789

I want to have one cell that merges these values into 123456789

Any ideas if this can be done?

Thank you for the quick response!

"bigwheel" wrote:

cell 4
=A1&B1&C1

"Mpls501sMan" wrote:

How do I merge the values in three cells into one. The example is I have
three cells

Cell 1 cell 2 Cell 3
123 456 789

I want to have one cell that merges these values into 123456789

Any ideas if this can be done?