+ Reply to Thread
Results 1 to 3 of 3

Collecting numeric infromation from string

  1. #1
    Forum Contributor
    Join Date
    03-05-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    301

    Collecting numeric infromation from string

    Hi all,

    I have a string that looks like this: TaskName-UnitNumber-OrderNumber, e.g TaskName-1-1

    The numeric values may change. e.g: TaskName-2-2, TaskName-10-98

    I need a fairly simple function that would return the Unitnumber and the Ordernumber from the string.

    Has anybody some ideas?

    Cheers

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Collecting numeric infromation from string

    Say your TaskName-2-2 is in cell A1. You would put =Unitnumber(A1) in any cell like B1. =Ordernumber(A1) in any cell like C1

    Please Login or Register  to view this content.
    If you need to to return both in the same cell

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    03-05-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    301

    Re: Collecting numeric infromation from string

    Thanks stnkynts

    This is brilliant. I just ran this to see how it worked. I didnt know about split but I will now look into it.

    Take a rep for the response.

    cheers

+ 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] Need code to pull numeric data out of an alphanumeric string (string not constant)
    By harrydnyc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-09-2013, 04:44 PM
  2. [SOLVED] Extract a mainly numeric string (ISSN number) from an arbitrary string
    By Buzzed Aldrin in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-04-2012, 01:49 PM
  3. Extracting Numeric Values from an Alpha/Numeric String
    By Delkath in forum Excel General
    Replies: 5
    Last Post: 10-27-2010, 02:36 PM
  4. Numeric value from a text string/numeric identifier?
    By lampshell in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-14-2008, 02:21 PM
  5. Replies: 3
    Last Post: 08-10-2006, 07:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1