lrchapman
New member
- Joined
- Dec 19, 2018
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 16.16
View attachment orders_export (7).xls
Hi there! Does anyone know a quick, easy formula to concatenate the colours that a person has chosen, separated by a comma, then a space, and then the next colour chosen? I want it to be that every person's choice is found in one cell and not in multiple cells. Do I need to use an IF statement? There could be 10 colours chosen per person so I don't want to keep having to choose the concatenate formula where I have to manually choose each cell to group together.
For ex. I want it to look like this:
Elena Kazakevic (cell A2) | Nude Pink, Grape, Yellow (cell C2)
Mallory McKewen (cell A2| Nude Pink, Grape, Sky (cell C5)
etc.
I have attached the file for anyone to review and provide their input!
Thank you!
Lana
Hi there! Does anyone know a quick, easy formula to concatenate the colours that a person has chosen, separated by a comma, then a space, and then the next colour chosen? I want it to be that every person's choice is found in one cell and not in multiple cells. Do I need to use an IF statement? There could be 10 colours chosen per person so I don't want to keep having to choose the concatenate formula where I have to manually choose each cell to group together.
For ex. I want it to look like this:
Elena Kazakevic (cell A2) | Nude Pink, Grape, Yellow (cell C2)
Mallory McKewen (cell A2| Nude Pink, Grape, Sky (cell C5)
etc.
I have attached the file for anyone to review and provide their input!
Thank you!
Lana