Function, dont know what its called
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
|