Share via

Combine Cells

Anonymous
2013-05-02T15:31:28+00:00

How do I combine 2 cells (one is area code & one is phone number) into one cell as 10-digit phone number? I tried =A1,B1; =A1&" "&B1; =A1&B1. None performed the concatenation. I have all cells formatted as text.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-05-02T15:44:05+00:00

    How do I combine 2 cells (one is area code & one is phone number) into one cell as 10-digit phone number? I tried =A1,B1; =A1&" "&B1; =A1&B1. None performed the concatenation. I have all cells formatted as text.

    Hi

    The first one (=A1,B1) doesn't work but both of the others should work fine. What result did you get from the second and third formula?

    Was this answer helpful?

    0 comments