Add spaces between text and numbers

I need to seperate text from numbers but i've tried text to columns and if is number formulas and its not working.

Here is a couple examples...

139ENSEMBLE
6496AMERICAN EXPRESS TRAVEL S
41101SIGNATURE TRAVEL NETWORK
Accr 432889INTERLINE TRAVEL &


I need to find the numbers and seperate it from the Name.

Here is my current formula.
=RIGHT(AA5,LEN(AA5)-MIN(IF(1*ISNUMBER(1*MID(AA5,ROW(INDIRECT("Aa2:Aa"&LEN(AA5))),1)),ROW(INDIRECT("Aa2:Aa"&LEN(AA5))),LEN(AA5)+1))*OR(ISNUMBER(1*LEFT(AA5,1)),ISNUMBER(1*RIGHT(AA5,1)))+1)

Appreciate the help.

that was perfect! thank you.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save