+ Reply to Thread
Results 1 to 5 of 5

Find word in text string and return word adjacent to the left

  1. #1
    Registered User
    Join Date
    05-06-2014
    Location
    Salt Lake City, UT
    MS-Off Ver
    Excel 2013
    Posts
    10

    Find word in text string and return word adjacent to the left

    Hi,

    I have a list of data I'd like to search using a specific word and return the adajcent word. e.g. in cell b2 I have a name of an organization: The Example Organization. If I am searching for "organization," I want the function to return "Example."

    Can anyone give me some guidance?

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Find word in text string and return word adjacent to the left

    Hi and welcome to the forum!

    One example is usually not enough to guarantee success in all cases. Can you upload a workbook with perhaps a dozen examples and your desired result in each case?

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Registered User
    Join Date
    05-06-2014
    Location
    Salt Lake City, UT
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Find word in text string and return word adjacent to the left

    Here is an example column of data:

    COLUMN A:

    Aids Healthcare Foundation Disease Managment of Florida Inc.
    Alliance for Childhood Diseases
    Alzheimers Disease & Related Disorders Association


    I'd like to see the results of Column B to be:

    Foundation
    Childhood
    Alzheimers


    So the function is finding the word directly to the left of "Disease"

  4. #4
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Find word in text string and return word adjacent to the left

    Hi,

    =TRIM(RIGHT(SUBSTITUTE(REPLACE(A1,FIND("Disease",A1),999,"")," ",REPT(" ",999)),1998))

    Regards

  5. #5
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Find word in text string and return word adjacent to the left


+ 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] Excel - Get the Word to the Left or Right of Another Word (text string)
    By sweetrevelation in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-22-2013, 01:36 PM
  2. Replies: 2
    Last Post: 08-05-2013, 04:45 PM
  3. Which function to find a words in word string and return them
    By majo. in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-27-2013, 09:08 AM
  4. [SOLVED] find word in string, count how many special characters are to its left
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2013, 06:46 PM
  5. [SOLVED] Find, Return 1st number/word in adjacent column
    By wkhor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-11-2012, 12:10 AM

Tags for this Thread

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