Results 1 to 5 of 5

Search and extract multiple words from an excel cell

Threaded View

fsm458 Search and extract multiple... 05-18-2022, 10:17 PM
Phuocam Re: Search and extract... 05-18-2022, 10:25 PM
Gregb11 Re: Search and extract... 05-18-2022, 10:31 PM
fsm458 Re: Search and extract... 05-18-2022, 11:21 PM
Gregb11 Re: Search and extract... 05-19-2022, 06:53 AM
  1. 05-18-2022, 10:31 PM #3
    Gregb11 is offline
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    3,178

    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
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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. [SOLVED] extract a word from a cell containing multiple words and placing it in an adjacent cell
    By dopera in forum Excel Formulas & Functions
    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. Search box in Excel to search key words in sentences in multiple worksheets
    By fernandoii676 in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1