Hi Friends,

Could you please suggest two formula that will give me numbers only in one column and characters in another column

20001 SYDNY-BRIDGE
2002 SYDNY-CHINA
203 SYDNY_WYN
20700000 BROADWAY


there are spaces before the characters

thanks heaps