Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you merge data from numerous cells into just one cell?
I have a list of around 4 thousand people. Each person belongs to one "Group"
which is tagged with a number. Basically there are two columns one showing the name and one with the group tag. What i want to do is have the group tags showing all the people who belong to that group. So I need to merge the data from a number of cells into one cell without losing the data. Any ideas? Thanks for your help. |
#2
|
|||
|
|||
Try:
=B3&""&C3&""&D3 I added the "" so a space is included in between cells. You can remove it if you don't need a space. "Senior" wrote: I have a list of around 4 thousand people. Each person belongs to one "Group" which is tagged with a number. Basically there are two columns one showing the name and one with the group tag. What i want to do is have the group tags showing all the people who belong to that group. So I need to merge the data from a number of cells into one cell without losing the data. Any ideas? Thanks for your help. |
#3
|
|||
|
|||
Make sure that there is a space between the quotation marks. (I didn't in my
origninal post, oops.) =B3&" "&C3&" "&D3 "StinkeyPete" wrote: Try: =B3&""&C3&""&D3 I added the "" so a space is included in between cells. You can remove it if you don't need a space. "Senior" wrote: I have a list of around 4 thousand people. Each person belongs to one "Group" which is tagged with a number. Basically there are two columns one showing the name and one with the group tag. What i want to do is have the group tags showing all the people who belong to that group. So I need to merge the data from a number of cells into one cell without losing the data. Any ideas? Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I merge two cells without deleting data from the cell? | Excel Discussion (Misc queries) | |||
retaining data after source cells move | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Count cells with data | New Users to Excel |