just how automatic do you need it to be?

the quickest solution i can think of, without resorting to vba, would be:
(assuming your data starts in cell E5)

for the category: =LEFT($E$5;FIND(" ";$E$5)-1)
for the number: =RIGHT(OFFSET($E$5;COLUMN(A1)-1;0))