Hi,
I need to extract Text from a cell to different columns.
Eg : a cell is containing below text
I need the TEXT starting IN1 in different columns. (Character Length : 10)
Here my output in different columns is as below
<tbody>
</tbody>
Help me to make a formulae for this.
Thanks in advance.
B.Srinivasa Rao
I need to extract Text from a cell to different columns.
Eg : a cell is containing below text
- S/N: IN17001671 BATCH:JAN/17 IN13022537 Batch Mar 17 , IN13022385; IN13022378
I need the TEXT starting IN1 in different columns. (Character Length : 10)
Here my output in different columns is as below
Text | Column 1 | Column 2 | Column 3 | Column 4 |
S/N: IN17001671 BATCH:JAN/17 IN13022537 Batch Mar 17 , IN13022385; IN13022378 | IN17001671 | IN13022537 | IN13022385 | IN13022378 |
<tbody>
</tbody>
Help me to make a formulae for this.
Thanks in advance.
B.Srinivasa Rao