How can I set up the ability to chose more than one option for a data validation list and list them in one cell? So I have a validation list of A B C D. I want to chose A C D and have those three options display in one cell.
I only want to have values of A, B, C, D but I want to be able to select more than one value and have it appended in the same cell. So after I select A, I can then select B and the cell would contain A, B.