Results 1 to 3 of 3

how to separate numbers from the text

Threaded View

nsd3 how to separate numbers from... 12-10-2010, 11:02 PM
Marcol Re: how to separate numbers... 12-10-2010, 11:13 PM
nsd3 Re: how to separate numbers... 12-11-2010, 10:25 AM
  1. #1
    Registered User
    Join Date
    07-18-2008
    Location
    Australia
    Posts
    40

    how to separate numbers from the text

    Hi,

    I need a formula to separate data from one column and show it divided in 2 columns. For example:

    "1 LITTLE COLLINS STREET" is currently in Column A
    The formula should show this as below:

    Column B - 1
    Column C - LITTLE COLLINS STREET

    The issue is there are numbers of 1 digit, 2 digits, 3 digits etc. I need only one formula that will separate the street names from the Street numbers.

    File is attached herewith. Thanks in advance for your support.

    Regards.
    Attached Files Attached Files
    Last edited by nsd3; 12-11-2010 at 10:26 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1