I need to split the column into text please can someone tell me how to do this in google sheets
<tbody>
</tbody>
Above is an example of how the column needs to be split into text in google sheets
AJANTPHARM19JAN1180CE | CE | AJANTPHARM | 19JAN | 1180 |
ADANIPOWER19AUG65CE | CE | ADANIPOWER | 19AUG | 65 |
APOLLOHOSP19AUG1400CE | CE | APOLLOHOSP | 19AUG | 1400 |
<tbody>
</tbody>
Above is an example of how the column needs to be split into text in google sheets