separating text and numbers in cells in the same order

[aganesan99]

Hello All,

I am having a report with cells having the attached data.

Could you please help me in separating the text and numbers in the same order in different cells using formula.

Thanks in advance!!

Regards,
aganesan99

[hoyasaxa215]

Might be better if you could provide a few more examples. Will the text have consistent punctuation? Is it only the first 4 characters that will change order between text and numbers?

[aganesan99]

Thanks for the reply.

Please find attached the file updated with one more example which I came across atlast.

Thanks,
aganesan99