Search element in comma separated list based on substring match in Google Sheets-CodePudding

CodePudding

Home > Software engineering > Search element in comma separated list based on substring match in Google Sheets

Search element in comma separated list based on substring match in Google Sheets

Time：07-07

I have list of data containing comma separated department wise orders in column-B, which is outlined in a format like:

Order_Num-X1|Dept_Name-Y1,Order_Num-X2|Dept_Name-Y2

and so on...

See the below table:

Is it possible to split and distribute the data in corresponding department column as outlined in Column-C, Column-D, Column-E? I tried as suggested in this

Page link：https//www.codepudding.com/Softwareengineering/467087.html

Prev:Intercalate multiple columns when some of those columns must remain in the same row

Next:How to add an argument and a dynamic range to a google sheets?

Tags：

google-sheets

google-sheets-formula

Links：
CodePudding