Ecel Dumbo
Member
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
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