Spreadsheet: 271234d1381868053-i-have-a-data-with-numbers-with-letters-in-single-cell-i-need-to-split-numbers-and-names-split-numbers
Sheet: Sheet1

RENTAL_SERVICES | service 1 | service 2 | service 3 | service 4 | service 5 | service 6 | service 7 | service 8
1|1645|10659 | 1 | 1645 | 10659
1|1645 | 1 | 1645
1 | 1 |  |  |  |  |  |  |  |  | hi all...  I want split like this, and if not data there should be blank is better
1 | 1
1 | 1
1 | 1
1|10659 | 1 | 10659
1
1
1
1
1
1
1
1
1
1
1|1645
1|1645
1
1
1|1645
1|1645
1
1
1|1645|10483
1|10177
1|1645|9774
1
1
1
1
1
1
1|1645|9774
1
1
1
1|1645|9774
1
1
1|1645
1
1
1
1|1645|9338
1
1
1|1645
1|1645
1|1645
1|1645
1|1645
1
1
1
1
1
1|1645
1
1
1|1645
1
1|1645
1
1|1645
1
1|1645
1|1645|9774
1|1645
1
1
1
1
1
1
1|1645
1|1645
1|1645
1
1
1
1
1
1
1|1645
1
1|1645|9774
1|10660
1
1|1645|9774
1|1645
1|1645|9774
1|1645|9774
1
1
1
1
1|1645
1|2967
9077|10192
1|1645
1|1645
1
1
1|1645
1|1645
1
1
1
1|1645|9774|9776
1
1
1|1645|9774
1
1
1
1|1645|9338|9774
1|1645
1|1645
1
1
1
1
1
1
1
1|1645
1
1|1645
1
1
1|1645
1
1
1
1
9077|10192
9077|10192
1
1|1645
1
1
1
1|1645|9774
1|1645|9774
1
1
1
1
1|10156
1
1
1|1645|9774
1|1645
1
1|1645
1
1|1645
1
1
1|102|1645
1|1645
1
1
1
1|1645
1|1645|9774
1
1|1645|9774
1
1
1
1
1
1
1
1
1|1645
1|1645|9338
1
1
1|1645
1|10156
1|1645
1
1|1645
1|1645
1
1|1645
9077|10192
9077|10192
1
1|1645
1
1|1645
1
1
1|1645
1
1
1
1
1
1
1
1
1
1
1
1|10156
1|1645
1
1
1
1
1
1|1645
1
1
1
1
1
1|1645|9338
1
1
1
1
1|1645|9338
1
1
1|1645|9774
1
1
1
1|1645|9774
1|1645
1
1|1645|9774
1
1
1
1
1|1645
1
1
1
1
1
1
1
1
1
1
1|1645
1
1
1
1
1
1
1|1645
1|1645
9077|10192
1
1
1
1|1645|10483
1
1
1
1
1
1
1|1645|10931
1
1|1645|9774|9776
1
1|1645
1
1|1645|9774
9077|10192
1
1
1
1|1645
1
1
1
1|1645|10483
1
1
1
1|1645
1
1
1
1|125|1645
1
1
1|1645|6617|9774|9776
1
1
1
1
1
1
1
1
1
1
1|1645|9774
1
1
1
1|1645
1|1645|10483
1|2967
1|1645
1
1|1645
1
1
1|2603
1
1|1645
1
1
1
1
1
1
1
1
1
1
1|2967
1
1
1|1645
9077|10192
1
1
1
1
1
1|1645
1|1645|9338|9774
1
1|1645
1
1
1
1
1|2967
1|1645|9774|9776
1|1645|9338
1|1645
1
1
1
1
1
1
1|1645
9077|10192
1|1645|9338
1
1
1|1645
1
1
1|1645|9774
1
1
1
1|1645
1
1|1645
1
1
1
1|1645|9774
1|1645
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1|1645
1
1
1
1
1|1645|9338
9077|10192
1|1645
1|1645|9774|9776
1|1645
1
1|1645
1
1
1
1
1|1645|10483
1
1
1
1
9077|10192
1
1|1645|9774|9775
1
1
1
1|1645
1
1|1645|9774|10481
1|1645
1
1|1645
1
1|1645
1
1|1645
1
1
1
1|1645
1
1
1
1
1
1
1|1645
1|1645
1|1645|9774
1
1
1
1
1
1|1645|9774
1
1
9077
1
1|1645
1|1645
1
1
1|2967
1|2967
1
1|1645
1
1
1
1
1
1
1
1
1|1645|9774|9776
1
1|1645
1
1
1
1
1
1|1645
1|1645
1
1
1
1|1645|9774
1
1|1645
1|1645
1|1645
1
1
1
1|1645
1
1
1
1|1645
1
1
1
9077
1|1645
1
1
1
1|1645|9774
1
1
1
1|1645|9774|9776
1
1|1645
1
9077|10192
1|1645
1|1645
1
1|1645|9774
1
1|1645
1
1|1645
1|1645
1
9077|10192
1|1645
1|1645
1|2603
1|1645|2967|9774
1
1
1|10156
1
1
1
1|1645|9338|9774|9776
1
1|1645|9774
1
1
1
1
1
1|1645|9774|9775
1|1645|9774|9776
1
1
1
1|1645|9338
1|1645|9774
1
1
1
1|1645|9774
1|1645|9774
1
9077|10192
1
1
1
1
9077|10192
1
1
1
1
1|1645|9774
1|1645
1
1
1|1645|9774
1
1
1|1645|9776|10156
1
1
1|1645|9338
1|2967
1|1645
1|1645
1|1645|9774
1
1
1
9077|10192
1|6617|10659
1|1645
9077|10192
1
1
1|1645
1|2967
1|1645
1
1
1
9077|10192
1|2967
1
1
1
1
1
1
1|1645|9338
1
1|2967
1|1645
1|1645
1|1645
1|1645
1|2967
1
1|1645
1|1645
1|1645
1
1|1645|9774
1
1
1
1|1645
1|1645|9774
1|1645
1
1
1
1|1645|9774
1
1
1
9077|10192
1|1645|9774|10481
1|1645
1|1645|10659
1
9077|10192
1
1
1
1|1645|9774
1
1
1|1645
1
1
1
9077|10192
1
1
1
1
1
1
1
1|2967
1
1
1|125
1
1|6507
1
1
1
1
1
1
1
1
1
1|1645|10659
1
1
1
1|1645
1
1
1
1|1645
1
1
1
1|1645|9338
1|1645
1|1645
1
1
1|1645
1|1645
1
1
1|1645|9774
1
1
9077|10192
9077|10192
1|1645
1|1645|9774
1
1
1
1
1
1|1645
1
1|1645|9774
1
1|1645
9077|10192
1
1
1
1|1645|9774
1
1
1|1645
1
1
1
1
1
1
1
1
1|1645|9774
1|1645
1
1|1645|9774
1
1
1|1645
1
1
1
1
1|1645|9774
1|1645|9774
1|1645
1
1
1
1
1
1|1645|9774
1
1|1645|9338
1|1645
1
1
1
1
1
1
1
1
1
1
1
1
1|1645
1
1|1645
1
1|1645
1|2967
1
1
1|1645
1
1
1|1645|10931
1
1|1645
1
1
1|1645
1|1645
1
1
1|9902
1
1|1645
1
1|2967
1
1
1
1|10156
1
1|10659
1|1645|10660
1|1645
1|1645|9105|9774|9776
1
1
1
1
1
1
1|1645
1
1
9077|10192
1
1|1645
1
1|1645
1