How to Merge seperate cells into 1 cell.

0

I am trying to figure how to take multiple cells, such as a name (first, middle, last) that are in 3 seperate cells and merge them into 1 cell either with spaces or commas.

Thank you,

Jeff Smith

Answer
Discuss

Answers

0

Would this work for you?

=CONCATENATE(A1," ",B1," ",C1)

or

=A1 & ", " & B1 & ", " & C1
Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login