Dear NARAYANK991,
In Input, S1,S2,S3,S4 is sheet no,and other is part no except SE**** - *.
some time, two part no can come in single cell between the "space". Some time Part no and "SE" Can come in single cell.
The output is, S1 is one cell and other part no is another cell as already...