Shortcuts – Combining Text from Multiply Cells

To combine text use the &.
Entering the following into a cell will combine the text contained in cell A1, A2 and A3 and place a space between each cells text.
=A1&” “&A2&” “&A3

Leave a Reply