How to separate numbers from text??

Here are my sample cells:


A---------------B---------------C------------D
ABA_______________________________123456789SMITH
ABA
ABA
ABA
ABA

I want to go from the example at the top to the example at the bottom. I would like to be able to separate the numbers and text that are in column D. The text will go to column B and the text (name) will go to column C. Is there a function or formula that will allow me to separate numbers from text?

A---------------B---------------C------------D
ABA______123456789_____SMITH______
ABA
ABA
ABA
ABA


PD: How the heck can I post a sample that looks like a spreadsheet????