sample.xlsx
I have uploaded a sample of data i need to sort out. In this, the string &&parent=xyz&& is common in every line of every cell. I need to identify this string and copy the line of the cell to another cell. there are 3 kinds of xyz so end result should be 3 columns with each cell containing the same &&parent=xyz&& string (i.e. same xyz).