+ Reply to Thread
Results 1 to 4 of 4

Formula to separate number and text

  1. 10-18-2016, 11:10 AM #1
    amandakayelitte
    amandakayelitte is offline
    Registered User
    Join Date
    02-02-2015
    Location
    evansville, in
    MS-Off Ver
    2010
    Posts
    26

    Formula to separate number and text

    Is there a formula to separate numbers and text in a measurement? For example, I have a list of different part number measurements that I need to separate in 3 different columns and not all are in the same format. Any help would be appreciated. Example below:


    Ship Dimensions
    11x8x1
    22x14x11
    22x15x12
    22x15x12
    13x11x7
    25x17x4
    24x17x8
    11x5x1
    11x5x1
    11x5x1
    11x5x1
    11x5x1
    7x5x2
    10x8x2
    12x10x4
    12x10x4
    12x10x4
    10x8x5
    12x9x8
    12x9x8
    4x2x1
    8x3x1
    12x9x8
    15x15x6
    25x10x1
    31x2x2







    4x2x1




    5x2x1
    5x2x2
    4x4x1
    8x6x4
    9x6x4
    6x4x4
    8x5x4
    6x4x4
    5x4x2
    7x5x2

    7x5x1

    11x9x2

    9x5x1
    9x5x1
    9x5x1
    14x9x2
    17x11x2
    17x11x3
    17x11x3
    1711x3
    17x11x3
    17x11x3
    17x11x3
    17x11x3
    17x11x3
    17x11x3
    17x11x3
    17x11x3
    17x11x3
    17x11x1
    15x9x1
    15x9x1
    20x5x3
    20x5x3
    20x5x3
    20x5x3
    20x5x3
    20x5x3
    20x5x3
    20x5x3
    11x6x1
    11x6x1
    11x6x1
    11x6x1
    20x5x3
    20x5x3
    9x7x3
    9x7x3
    9x7x3
    10x8x8
    Reply With QuoteRegister To Reply
  2. 10-18-2016, 11:15 AM #2
    jason.b75
    jason.b75 is offline
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Formula to separate number and text

    How about text to columns, using x as delimiter?
    Reply With QuoteRegister To Reply
  3. 10-18-2016, 11:19 AM #3
    amandakayelitte
    amandakayelitte is offline
    Registered User
    Join Date
    02-02-2015
    Location
    evansville, in
    MS-Off Ver
    2010
    Posts
    26

    Re: Formula to separate number and text

    I had forgotten about that. Thanks for the reminder, much appreciated!
    Reply With QuoteRegister To Reply
  4. 10-18-2016, 11:28 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Formula to separate number and text

    Use the text to columns function, with x as the delimiter.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    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] formula for separate number from Text
    By AaruJaan in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-07-2016, 02:40 PM
  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. Separate number from text
    By sriku in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-04-2014, 10:09 AM
  4. Separate Text & Number
    By jpeifer03 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-13-2014, 05:22 PM
  5. How do I separate text from a phone number in one cell?
    By watchoverme in forum Excel General
    Replies: 21
    Last Post: 01-12-2014, 05:32 PM
  6. [SOLVED] Formula to separate number from text
    By alcharbonneau in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-26-2013, 06:13 PM
  7. [SOLVED] separate text, number
    By marreco in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-21-2012, 09:09 AM

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