Combine text from multiple cells into one cell with spaces. &

In this formula you are taking the contents from different cells and putting them together into one cell with space included. To accomplish this, you use the ampersand (&) sign to combine text and quotations (” “) with a space between them to show spacing.

This is what your formula will look like

=A1&” “&B1&” “&C1&”.”

If you need to add an additional word to your work here is what that formula will look.

=A2&” “&”just”&” “&B2&” “&C2&”.

Leave a comment