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
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
Would this work for you?
=CONCATENATE(A1," ",B1," ",C1)
or
=A1 & ", " & B1 & ", " & C1