Thanks in advance for your review of this query!
Looking to convert a group of values in a single cell that are separated by commas into a matching list of strings separated by commas.
For instance, I'm using the following formula when only two values have been entered :
=TRIM(CONCATENATE(INDEX(M:M,MATCH(VALUE(LEFT(C4,FIND(",",C4)-1)),L:L,0))," ",INDEX(N:N,MATCH(VALUE(LEFT(C4,FIND(",",C4)-1)),L:L,0))," & ",INDEX(N:N,MATCH(VALUE(RIGHT(C4,LEN(C4)-FIND(",",C4)-1)),L:L,0))))
33205, 90149 > flavors : banana & licorice
Is there a "kinder" solution for this? What if more than two values are entered?
33205, 78596, 90149 > flavors : banana, pumpkin, licorice
See attached table for values and strings.
artikyulashun
Bookmarks