+ Reply to Thread
Results 1 to 3 of 3

Split from string

  1. 08-30-2018, 10:46 AM #1
    tax112
    tax112 is offline
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    442

    Split from string

    Hi everybody
    Can someone help me to use the formula to extract the number as attached.
    Thank you.
    5.png
    Reply With QuoteRegister To Reply
  2. 08-30-2018, 10:51 AM #2
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Split from string

    Try this
    Enter in B1 and copy down
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    v A B
    1 PP155KA 55
    2 AB2123LX 123
    3 QE1456PO 456
    4 AA11234XP 1234
    5 PQ216RY 16
    Or this
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Last edited by AlKey; 08-30-2018 at 10:57 AM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  3. 08-30-2018, 10:59 AM #3
    tax112
    tax112 is offline
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    442

    Re: Split from string

    Thank you very much.
    Last edited by alansidman; 08-30-2018 at 12:02 PM.
    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] Split String
    By calvinle in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-31-2016, 06:34 PM
  2. [SOLVED] Split string and apply function on string parts
    By fandreacci in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-25-2015, 12:34 PM
  3. [SOLVED] Split String at every "/" then put split string results into a multiline textbox.
    By Andrew Andromeda in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2015, 01:49 AM
  4. How to split a string based on a sub string
    By dippa in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 11-24-2014, 08:04 PM
  5. Advanced Split Function: Need to pull text string in quotes, within a text string
    By Zamboni in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-27-2013, 04:38 PM
  6. Can excels Split() function split a string up at multiple spots?
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2011, 02:36 PM
  7. Split string?
    By JapanDave in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-26-2011, 07:40 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