Separate numbers vs letters into different columns

[myerkate16]

Hello!

I have a trial balance raw export that has the account and the Description in the same column with varying leading spaces, varying digits in the account, as well as varying spaces between the Account and the Description. Is there a way to separate the account and the Description into 2 separate columns?

Thanks!

[ShankerV · Accepted solution]

Hi @myerkate16 

Please find the expected output.

Many thanks

Shanker V

[myerkate16 · Accepted solution]

Thanks!