Data Validation with a string in a cell

I have used Textjoin to create a string with comma delimiter in cell C1, lets say the string is "a,b,c,d,e" in the cell. I tried to refer $C$1 as the source for the list option in data validation, bu...