There is an excel sheet with Emails in a column named EMAIL
there are multiple emails separated by "||"
I want to retain the valid emails - in one column and separate the not so good emails /data to another column
<tbody>
1
3SI@12T.QMNgC || FFo@a46ZZi.g || ri@80.jiBjX0G || Z9G@85YU.Pb ||...