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

**URL:** <https://boards.straightdope.com/t/need-help-in-excel-append-data-from-different-cells-into-one-cell/300236>\
**Category:** Factual Questions\
**Created:** [April 20, 2005, 3:14pm UTC](https://boards.straightdope.com/t/need-help-in-excel-append-data-from-different-cells-into-one-cell/300236 "2005-04-20T15:14:51Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Whack-a-Mole](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/whack-a-mole/32/141_2.png) [@Whack-a-Mole](https://boards.straightdope.com/u/Whack-a-Mole)\
**Post date:** [April 20, 2005, 3:14pm UTC](https://boards.straightdope.com/t/need-help-in-excel-append-data-from-different-cells-into-one-cell/300236/1 "2005-04-20T15:14:51Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Terminus\_Est](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/terminus_est/32/3087_2.png) [@Terminus\_Est](https://boards.straightdope.com/u/Terminus_Est)\
**Post date:** [April 20, 2005, 3:19pm UTC](https://boards.straightdope.com/t/need-help-in-excel-append-data-from-different-cells-into-one-cell/300236/2 "2005-04-20T15:19:23Z")

</div>

Look up the “concatenate” function:

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

---

<div class="post-metadata">

**Author:** ![Balthisar](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/balthisar/32/2825_2.png) [@Balthisar](https://boards.straightdope.com/u/Balthisar)\
**Post date:** [April 20, 2005, 3:19pm UTC](https://boards.straightdope.com/t/need-help-in-excel-append-data-from-different-cells-into-one-cell/300236/3 "2005-04-20T15:19:52Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Mangetout](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/mangetout/32/19_2.png) [@Mangetout](https://boards.straightdope.com/u/Mangetout)\
**Post date:** [April 20, 2005, 3:20pm UTC](https://boards.straightdope.com/t/need-help-in-excel-append-data-from-different-cells-into-one-cell/300236/4 "2005-04-20T15:20:42Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Mangetout](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/mangetout/32/19_2.png) [@Mangetout](https://boards.straightdope.com/u/Mangetout)\
**Post date:** [April 20, 2005, 3:22pm UTC](https://boards.straightdope.com/t/need-help-in-excel-append-data-from-different-cells-into-one-cell/300236/5 "2005-04-20T15:22:18Z")

</div>

Aha, great minds and so on…

---

<div class="post-metadata">

**Author:** ![Whack-a-Mole](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/whack-a-mole/32/141_2.png) [@Whack-a-Mole](https://boards.straightdope.com/u/Whack-a-Mole)\
**Post date:** [April 20, 2005, 3:33pm UTC](https://boards.straightdope.com/t/need-help-in-excel-append-data-from-different-cells-into-one-cell/300236/6 "2005-04-20T15:33:49Z")

</div>

Excellent all.

Dopers rock! Thanks a million!