splitting a column in Access

Hey there!

Does anybody know how I can split a column in Access with VB? The problem is that the field contains text and numbers but the text can be multiple words.

For instance:

abc def 1234

abd def 5678

I want to split the numbers and the text into two seperate columns.

Thanx a lot.

[339 byte] By [DJRave] at [2008-1-6]