+ Reply to Thread
Results 1 to 5 of 5

Search and extract multiple words from an excel cell

  1. #1
    Registered User
    Join Date
    05-18-2022
    Location
    Canada
    MS-Off Ver
    365
    Posts
    2

    Search and extract multiple words from an excel cell

    Hi,

    I am working on an excel sheet for a project and needs to pull multiple words from a cell.

    Example:
    ABD Chevrolet Buick Cadillac - Need to pull the brand names (Chevrolet, Buick, Cadillac) and place in a single cell. If not possible, 1 brand each cell.
    GHM Buick and GMC - pull "Buick" and "GMC" to a cell
    Do i need to make a reference table with all the brands for this to work?

    I've tried and search a couple of functions but nothing seems to work.

    Thanks in advance!

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2024
    Posts
    6,174

    Re: Search and extract multiple words from an excel cell

    Quote Originally Posted by fsm458 View Post
    Do i need to make a reference table with all the brands for this to work?
    Yes, you need a reference table and use the TEXTJOIN function.

  3. #3
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    3,177

    Re: Search and extract multiple words from an excel cell

    If you put all your Brand Names into a table, maybe try this:

    =TEXTJOIN(", ",TRUE,IF(ISNUMBER(SEARCH(Table1[Brand Names],A2)),Table1[Brand Names],""))

    See attached.
    Attached Files Attached Files
    Last edited by Gregb11; 05-18-2022 at 10:31 PM. Reason: add attachment

  4. #4
    Registered User
    Join Date
    05-18-2022
    Location
    Canada
    MS-Off Ver
    365
    Posts
    2

    Re: Search and extract multiple words from an excel cell

    This is amazing! Thank you so much for your help!
    I've spent almost the whole day trying to figure this out as I have to do it for 9k records.

    Thank you so so much!

  5. #5
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    3,177

    Re: Search and extract multiple words from an excel cell

    You're welcome and thanks for the rep.

+ 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. Search multiple words in a single cell
    By ruissu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2016, 10:40 AM
  2. Search multiple words in a single cell
    By ruissu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2016, 10:38 AM
  3. [SOLVED] How to extract multiple words from one cell
    By katie88 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-03-2015, 08:18 PM
  4. Replies: 5
    Last Post: 01-10-2013, 09:51 AM
  5. [SOLVED] Search box in Excel to search key words in sentences in multiple worksheets
    By fernandoii676 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-05-2012, 01:42 PM
  6. Replies: 2
    Last Post: 10-19-2012, 11:11 AM
  7. How to search and extract specific words from an Excel worksheet ?
    By newbr33d in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-25-2008, 06:45 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