• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

To split numbers and characters

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
 
It seems, you have one space between number and Character. So you can use Text To Columns option to make it. Numbers in one column and text in another column.. Please try
 
Back
Top