Assuming that the address always starts with the street number, followed
by a space, and then the street name, try...

=LEFT(A1,FIND(" ",A1)-1)

and

=MID(A1,FIND(" ",A1)+1,1024)

Hope this helps!

In article ,
Michael wrote:

I have the following example:
A
1 13 main st
2 37892 Oak st
3 8237 54th St

I want to seperat the address from the street name in a seperate colum to
end up with the following:

A B
1 13 main st
2 7892 Oak st
3 48237 54th St

Any help would be greatly appreciated.

michael