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

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Split Column to text in google sheets custom

Thread starter epresent
Start date Jul 26, 2019
Tags

google split split columns split text and numbers text

epresent

New Member

Jul 26, 2019

I need to split the column into text please can someone tell me how to do this in google sheets

[TABLE="width: 500"]
<tbody>[TR]
[TD]AJANTPHARM19JAN1180CE[/TD]
[TD]CE[/TD]
[TD]AJANTPHARM[/TD]
[TD]19JAN[/TD]
[TD]1180[/TD]
[/TR]
[TR]
[TD]ADANIPOWER19AUG65CE[/TD]
[TD]CE[/TD]
[TD]ADANIPOWER[/TD]
[TD]19AUG[/TD]
[TD]65[/TD]
[/TR]
[TR]
[TD]APOLLOHOSP19AUG1400CE[/TD]
[TD]CE[/TD]
[TD]APOLLOHOSP[/TD]
[TD]19AUG[/TD]
[TD]1400[/TD]
[/TR]
</tbody>[/TABLE]

Above is an example of how the column needs to be split into text in google sheets