Splitting Account Number and Title

Select the column to split then click Data > Text to Columns



This starts the Convert Text to Columns Wizard


Select 'Fixed width'



Move the break lines at the end of the numbers and at the beginning of the titles



Specify an empty column to the right for Destination



The account numbers being in column E and account titles being in column G



you can simply edit the sheet to get the following trial balance