+ Reply to Thread
Results 1 to 4 of 4

How To Separate Numbers Mixed with Text in separate Colum

  1. #1
    Registered User
    Join Date
    04-15-2016
    Location
    Riyadh,Saudi Arabia
    MS-Off Ver
    MicroSoft Office 2010
    Posts
    3

    Question How To Separate Numbers Mixed with Text in separate Colum

    Dears,
    Some one help me to Separate Specific Format numbers from one column to other.
    Data is like this
    [8/15/2015 04:53:51 م] Abdullah Rowdan: 41404632592
    [8/16/2015 06:04:41 م] Abdullah Rowdan: 860070921096
    [8/16/2015 04:44:48 م] Khalifa Shifa: 9182059854
    30300225325
    So Numbers can be 10,11 or 12 Digit Length

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,652

    Re: How To Separate Numbers Mixed with Text in separate Colum

    Use Data==> Text-to-Columns=>Delimited=>other=> ":" (without quotes)==> next screen => Select last column and set to TEXT (radio button) => Finish

  3. #3
    Forum Contributor
    Join Date
    10-30-2014
    Location
    England
    MS-Off Ver
    2007 / 365
    Posts
    246

    Re: How To Separate Numbers Mixed with Text in separate Colum

    If ALL numbers are either 10, 11 or 12 digits in length, you can use =TRIM(SUBSTITUTE(RIGHT(A1,12),":",""))

  4. #4
    Registered User
    Join Date
    04-15-2016
    Location
    Riyadh,Saudi Arabia
    MS-Off Ver
    MicroSoft Office 2010
    Posts
    3

    Re: How To Separate Numbers Mixed with Text in separate Colum

    Thanks
    below one formula resolve my problem.
    =TRIM(SUBSTITUTE(RIGHT(A2,12),":",""))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Separate input numbers into separate columns.
    By Tona in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-16-2015, 04:23 AM
  2. [SOLVED] Excel2010 IF Formula to return value based on a separate date and two separate text values
    By jakecutler in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2015, 03:24 AM
  3. Replies: 4
    Last Post: 06-18-2014, 11:48 AM
  4. [SOLVED] Separate numeric/text combination into two separate columns.
    By Jim15 in forum Excel General
    Replies: 6
    Last Post: 10-09-2013, 05:49 PM
  5. Replies: 10
    Last Post: 03-08-2012, 12:31 PM
  6. Replies: 2
    Last Post: 09-24-2009, 06:51 AM
  7. Replies: 2
    Last Post: 08-23-2005, 03:49 AM

Tags for this Thread

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