I am trying to figure out to split a cell formated with a numeric and alpha
format. For example, the format is "10100 Accounts Payable"

I want to split the cells to "10100" (1st cell) then "Accounts Payable" (2nd
cell).

I have 2,700 cells to split, so I need efficient commands. Thanks.