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