PuffyGrl82
New Member
- Joined
- Feb 24, 2011
- Messages
- 1
Dear Mrexcel community,
I have been stuck trying to figure out something I'm sure some of you experts would consider simple. I have an Excel worksheet where column C has the first names of a list of company employees. As an example, we may have cell C1 = "Debbie", C2 = "James", C3 = "Tony"...
What I need to do is figure out an equation where I can somehow get all these first names separated by a comma and a space. It would be great if I could get cell D1 = "Debbie, James, Tony, ...".
Any help would be appreciated. I've been trying to figure this out for the past week to no avail. Thank you!
- Vivian
I have been stuck trying to figure out something I'm sure some of you experts would consider simple. I have an Excel worksheet where column C has the first names of a list of company employees. As an example, we may have cell C1 = "Debbie", C2 = "James", C3 = "Tony"...
What I need to do is figure out an equation where I can somehow get all these first names separated by a comma and a space. It would be great if I could get cell D1 = "Debbie, James, Tony, ...".
Any help would be appreciated. I've been trying to figure this out for the past week to no avail. Thank you!
- Vivian
