Hi,
below is a sample of my cell value;
248527/248528/248529/248690/248691/248692/248693/248694/248695
I want to separate each 6 digit numbers in different cells. So the result will looks like below;
The "/" delimiter will not change and the numbers will be always 6 digit.
Can any one help me please.
below is a sample of my cell value;
248527/248528/248529/248690/248691/248692/248693/248694/248695
I want to separate each 6 digit numbers in different cells. So the result will looks like below;
248527 | 248697 | 248529 | 248690 | 248691 | 248692 | 248693 | 248694 | 248695 |
The "/" delimiter will not change and the numbers will be always 6 digit.
Can any one help me please.