Extract text and numbers

[avishal007]

I want extract numbers and text from

LAXMI GANPATI ENTERPRISES19.475

In column one LAXMI GANPATI ENTERPRISES
In column Two 19.475

BALAMURLI ENTERPRISES
19.11

tks in advance

 

[avishal007]

thanks to all

all are works perfectly

thanks

 

[Rodel Geronimo]

Hi Peter, again you're the man.

Thank you so much.