Hi,

You may try the following array formula (Ctrl+****+Enter)

Assume that "10100 Accounts payable" is entered in cell A14. In B14 enter
the following array formula

=1*MID(A14,MATCH(TRUE,ISNUMBER(1*MID(A14,ROW($1:$1 9),1)),0),COUNT(1*MID(A14,ROW($1:$19),1))+IF(ISNUM BER(MATCH(".",MID(A14,ROW($1:$19),1),0)),1,0))

In cell D14, enter the following array formula

=MID(A14,MATCH(TRUE,ISERROR(1*MID(A14,ROW($1:$51), 1)),0),100+IF(ISERROR(MATCH(".",1*MID(A14,ROW($1:$ 51),1),0)),1,0))

I hop this helps. Please let me know if you need any further help on this.

My e-mail address is

Regards,


"FFB PFK" wrote:

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.