I think I know the answer but figured I’d ask anyway.
Does anyone know if it’s possible to create a dropdown list using a delimited set of data in a cell?
So, instead of creating a column with lookup values, my data is coming over prepopulated as:
a1 = “x,y,z” a2 = “a,b,c” a3 = “q,r,s”
I was hoping I could use data validation to turn the comma-delimited values that exist in the actual cell into dropdowns (either in the cell itself or by creating a new column).
Nothing appears to be available to support this.
You can hand-enter…but that’s no good in this scenario.
Anyone know of any custom formulas that can parse and generate a list like this?