I have a dimension list with 1 column where all items are in the following format: XYZ or XY/ABC.
I would like to add now a second column that will have 2 possible values: Product A or Product B (TEXT).
-If you detect a “/” in the cell, please say Product A
-If not, please say Product B
I believe it is a variation of using if contains/mid.. however, I do not find the right formula. Would it be possible to help?
Thank you very much!
Best answer by Issam MoallaView original