I need to get in D1 "A,B,C".
I need a formula that will find every word in A1 and compare from B1,B2...and replace it with text from C1,C2,C3
In the image below, you start with cell A1, separate the text by commas, find each piece in column B, replace it with the corresponding value in column C, and get the final result in D1.
In CSV, it would be:
"1,2,3","1","A","A,B,C"
"","2","B",""
"","3","C",""