Results 1 to 10 of 10

Extract string based on specific string

Threaded View

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Extract string based on specific string

    Hello everybody
    I have this value for example
    My name is Yasser Khalil
    I want to extract the name and the address based on the string (My name is) to extract (Yasser Khalil) the name consists of two parts (first name and second name) ..
    I also want to extract the address based on the string(and the address is) to extract the rest of the string(20 Salem st.,Cairo)
    Thanks advanced

    I appreciate if it can be done with a UDF function

    Moderator's note: Personal info removed, never a good idea to show that kind of info on public forum
    Last edited by FDibbins; 12-13-2014 at 05:42 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract specific numbers from a string of text
    By Galwaygirl13 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-19-2012, 03:22 PM
  2. Extract specific word from a text string
    By krjoshi in forum Excel General
    Replies: 10
    Last Post: 01-19-2012, 02:00 PM
  3. Extract String After Specific Word
    By Gingeiko in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-03-2011, 09:05 AM
  4. Replies: 11
    Last Post: 09-29-2011, 04:42 AM
  5. [SOLVED] Extract specific value from a long text string
    By Dinesh in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-10-2006, 11:30 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