I have a column of numbers that I need split into three columns. The numbers can have 8,9 or 10 digits. I need to split from the right into three columns
Current data
<tbody>
</tbody>
Desired result
<tbody>
</tbody>
Any help is greatly appreciated.
Thanks
Current data
235000035 |
75000035 |
1865000035 |
<tbody>
</tbody>
Desired result
23 | 5000 | 035 |
7 | 5000 | 035 |
186 | 5000 | 035 |
<tbody>
</tbody>
Any help is greatly appreciated.
Thanks