+ Reply to Thread
Results 1 to 4 of 4

Extract a word from a text in a tab

  1. #1
    Registered User
    Join Date
    03-28-2018
    Location
    ISRAEL
    MS-Off Ver
    2010
    Posts
    15

    Extract a word from a text in a tab

    Hi All,

    I would like to extract a word from a text, only with with formulas:

    "You have a new message: Via:xx Message Details: First Name Dror Last Name test Your Email xxx Job Title popo Direct Manager popo Team popop Form Name Presentation"

    The colored words should be extracted (in different cells).
    In each kine only those words are being changed.

    I tried the following formula but it returns
    =MID(A2, SEARCH("First Name",A2) + 1, SEARCH("last",A2,SEARCH("First Name",A2)+1) - SEARCH("last",A2) - 1)

    Any ideas?

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Extract a word from a text in a tab

    There are NO coloured words in your description of the problem.

    Try listing the words you want extracted.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Extract a word from a text in a tab

    Try this:

    =MID(A2, SEARCH("First Name",A2) +LEN("First Name")+ 1,
    SEARCH("last",A2,SEARCH("First Name",A2)+LEN("First Name")+ 1) - SEARCH("First Name",A2) -LEN("First Name")- 1)

  4. #4
    Registered User
    Join Date
    03-28-2018
    Location
    ISRAEL
    MS-Off Ver
    2010
    Posts
    15

    Re: Extract a word from a text in a tab

    Great, works!
    Thank you !

+ 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 Certain Text from Word into Excel Using VBA
    By mohan0509 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-20-2018, 11:23 PM
  2. [SOLVED] Extract data right of certain word in text
    By ScabbyDog in forum Excel General
    Replies: 2
    Last Post: 04-11-2013, 07:06 AM
  3. [SOLVED] Extract word from text
    By Aland2929 in forum Excel General
    Replies: 7
    Last Post: 05-09-2012, 06:41 AM
  4. [SOLVED] extract text after a certain word
    By marreco in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-11-2012, 07:10 AM
  5. Excel 2007 : Extract Data from Word/text
    By maverick09 in forum Excel General
    Replies: 2
    Last Post: 12-08-2011, 01:00 PM
  6. Extract text after a specified word
    By tahirfayyaz in forum Excel General
    Replies: 2
    Last Post: 01-24-2010, 04:54 PM
  7. Extract a text from word and place it en excel or word?
    By Elegidos in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2009, 06:14 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