I am having issues using Text to Column in order to split consecutive digits into two columns to ultimately run a chart of accounts. Is there also a way I can assign these fields a title (I.E. 11 = Current Asset, 12 = Non-Current Asset etc)
From
| Field 1 |
| 110002 |
| 111003 |
| 123003 |
| 124001 |
| 210011 |
| 221003 |
To
| Field 1 | Field 2 |
| 11 | 0002 |
| 11 | 1003 |
| 12 | 3003 |
| 12 | 4001 |
| 21 | 0011 |
| 22 | 1003 |
