+ Reply to Thread
Results 1 to 7 of 7

How to separate text from numbers (no fixed number pattern)

  1. 08-25-2014, 08:05 AM #1
    harelk
    harelk is offline
    Registered User
    Join Date
    08-25-2014
    Location
    Israel
    MS-Off Ver
    2007
    Posts
    7

    How to separate text from numbers (no fixed number pattern)

    Hello everyone.
    I've been busting my #$@ trying to find a solution for this, for quite a long time now.
    This is how my data is shown, for example, in the spreadsheet: (this language is hebrew)

    *תל אביב072-3268099
    *ירושלים072-3227610
    *פתח תקווה072-3270382
    *גבעתיים072-3251498
    *חולון072-3250538
    *רמת גן072-3223491
    *חולון072-3251360
    *רמת השרון1599525253
    *תל אביב072-3228013
    *מזור072-3218041
    *פתח תקווה072-3251106
    *ראשון לציון072-3268266
    *ירושלים02-5333588

    as you can see, the number length is not fixed, and sometimes there's a hyphen (-) separating the area code.
    I need to find a way to separate the text attached to the numbers.
    I'm helpless. The sheet contains about 600 rows.
    Any help is welcome.
    Thanks
    Reply With QuoteRegister To Reply
  2. 08-25-2014, 08:15 AM #2
    satputenandkumar0
    satputenandkumar0 is offline
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Re: How to separate text from numbers (no fixed number pattern)

    try

    Please Login or Register  to view this content.
    Regards,
    Nandkumar S.
    ---------------------------------------------------------------
    Don't forget to Click on * if you like my solution.
    Reply With QuoteRegister To Reply
  3. 08-25-2014, 08:54 AM #3
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: How to separate text from numbers (no fixed number pattern)

    If you want a VBA solution to achieve this, please find the attached sheet to see if this works as per your requirement.
    Attached Files Attached Files
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  4. 08-25-2014, 09:10 AM #4
    harelk
    harelk is offline
    Registered User
    Join Date
    08-25-2014
    Location
    Israel
    MS-Off Ver
    2007
    Posts
    7

    Re: How to separate text from numbers (no fixed number pattern)

    Quote Originally Posted by sktneer View Post
    If you want a VBA solution to achieve this, please find the attached sheet to see if this works as per your requirement.
    Worked like a charm. Amazing.
    Many thanks.
    Reply With QuoteRegister To Reply
  5. 08-25-2014, 09:13 AM #5
    harelk
    harelk is offline
    Registered User
    Join Date
    08-25-2014
    Location
    Israel
    MS-Off Ver
    2007
    Posts
    7

    Re: How to separate text from numbers (no fixed number pattern)

    Quote Originally Posted by sktneer View Post
    If you want a VBA solution to achieve this, please find the attached sheet to see if this works as per your requirement.
    Worked like a charm. Amazing.
    Many thanks.
    Reply With QuoteRegister To Reply
  6. 08-25-2014, 12:56 PM #6
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: How to separate text from numbers (no fixed number pattern)

    You're welcome.
    If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark your thread as solved.
    Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.
    Reply With QuoteRegister To Reply
  7. 08-26-2014, 03:27 AM #7
    harelk
    harelk is offline
    Registered User
    Join Date
    08-25-2014
    Location
    Israel
    MS-Off Ver
    2007
    Posts
    7

    Re: How to separate text from numbers (no fixed number pattern)

    Done and done. Thanks again.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Search for pattern of numbers in text
    By toontopo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2012, 04:37 AM
  2. [SOLVED] Search for pattern of numbers in text
    By toontopo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-07-2012, 11:35 AM
  3. How to separate numbers from text in a code (into a separate column)
    By Gooford in forum Excel General
    Replies: 10
    Last Post: 03-08-2012, 12:31 PM
  4. Exporting large number of columns along with 1 fixed column into separate text files
    By akshaynr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-13-2010, 11:08 AM
  5. Translating numbers into number with color pattern
    By Harry88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2006, 03:32 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1