How to combine contents of several cells into 1 cell (Not sum)

  • Thread starter Thread starter SuperstarPunani
  • Start date Start date
S

SuperstarPunani

Help!

I have a large spreadsheet with text that I need to combine (since it
is text can't use the Sum function).

Here's an example for 1 column.

Row 1 has "Kirkwood" (Cell A1)
Row 2 has "Chair 10" (Cell A2)
Row 3 has "The Wall" (Cell A3)
Row 4 has "Powder" (Cell A4)

Now I am trying to add up the contents of the 4 cells into Row 5 so
cell A5 shows "Kirkwood, Chair 10, The Wall, Powder".

Is there an easier way to do this rather than having to go to cells
A1-A4 and copying and pasting the contents of each cell into cell A5?

Thanks
 
Back
Top