Separate Acct Numbers from Name on P&L Standard/ BSheet

I am using QB enterprise 24 and I’m trying to separate out the GL account numbers from the name of the account because they come joined together in the same cell when I export to excel with a little . In between them.

Whether this is in the Profit and Loss Standard or Balance Sheet standard is there a way to have them each in their own column.

I have multiple intercompany accounts so this would make the reconciliation easier. Let me know if I am explaining this right or need to provide more context.

Edit to post: thanks and yes that would work but my accounts are listed as 6000.01, 6000.02 so i can’t separate it out using that method because it’s in mutliple places in a single cell. I’m looking to customize it as an export from QBooks without having to do manual excel work.