Need help in Excel (append data from different cells into one cell)

Factual Questions
1

I need to collect information displayed (the value displayed, not the formula) from several different cells in an Excel spreadsheet and have that info all display in one cell elsewhere.

For example:

Cell A1 = 52
Cell D23 = Sara
Cell H56 = XXX Corp
Cell J38 = 68.22

I would like all that info to appear in one cell as follows:

Cell Z1 = 52, Sara, XXX Corp, 68.22

Is there a way to do this?

2

Look up the “concatenate” function:

=concatenate(A1, ", ", D23, ", ", H56, ", " J38)

3

=a1 & ", " & D23 & ", " & H56 & ", " & J38

4

Or
=A1 & ", " & D23 & ", " & H56 & ", " & J38

5

Aha, great minds and so on…

6

Excellent all.

Dopers rock! Thanks a million!