+ Reply to Thread
Results 1 to 2 of 2

Extract name from a string, not constant data

  1. #1
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Extract name from a string, not constant data

    Hi there,

    Someone out there will know how to do this, I need to extract the name from the strings below,

    I have these in a single column and like I say the data/location of the name in the string is non constant, but I'd like a single formula to extract the name?

    Example strings below:

    RECODE TO 905541/51171001 FROM 905541/52141020 SSC BRUCE, EMMA A SEARLS W/E 20/11/2015
    RECODE TO 905551/51171001 FROM 905551/52141020 SSC ASHWINI, BHELOSE L THOMPSON W/E 19/09/2015

    Any ideas?

    Thanks
    seash

  2. #2
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Extract name from a string, not constant data

    Gives you the name between first comma- "," and "W/E" found in the cell A2-
    Please Login or Register  to view this content.
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

+ 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. Extract Data from a text string
    By Atul Maskara in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 09-08-2014, 08:56 AM
  2. [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
  3. How to extract a value of a constant that was stored in a string?
    By soldout2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2013, 07:46 AM
  4. Extract Data from a string
    By dcaraher in forum Excel General
    Replies: 13
    Last Post: 12-15-2010, 10:13 AM
  5. How to extract data from a string?
    By bunster in forum Excel General
    Replies: 4
    Last Post: 04-20-2009, 06:17 AM
  6. extract numbers from text or a constant
    By Stephanie in forum Excel General
    Replies: 9
    Last Post: 05-14-2006, 05:45 PM
  7. Extract data from String
    By SL in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-10-2006, 08: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1