+ Reply to Thread
Results 1 to 3 of 3

Extracting Information from a Column based on Keyword Table

  1. #1
    Registered User
    Join Date
    03-25-2021
    Location
    London, England
    MS-Off Ver
    Office 16
    Posts
    1

    Extracting Information from a Column based on Keyword Table

    Hello,

    I need some help as I have not been able to find the answer to this problem online.

    Basically, I have a large number (thousands) of cells with miscellaneous information out of which I need to extract specific word combinations. In another sheet I have a table of these specific keywords (e.g. white chair). As this information is combined with other words that are noises (e.g. white chair, treat with sandpaper, not water resistant), I'm wondering if there is a formula or another way to use the keyword table to recognize the words within a column and then extract the recognized words into another column.

    I have been able to use a formula to recognize whether or not the word is within the cell but can't figure out a way to extract those words automatically as they are recognized. This would significantly speed up the process as I currently have to use the filtering or find and replace options, which is making this a very manual task.

    Thank you very much in advance!

    Helen

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    Re: Extracting Information from a Column based on Keyword Table

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    Soft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Extracting Information from a Column based on Keyword Table

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
    Glenn



+ 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. Replies: 0
    Last Post: 04-19-2020, 06:16 AM
  2. [SOLVED] Userform: Add information into table based on row and column
    By Kyhosa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2019, 09:43 AM
  3. Replies: 3
    Last Post: 07-30-2017, 04:18 AM
  4. Extracting and comparing information from pivot table.
    By jonboy6257 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-14-2014, 06:14 PM
  5. Replies: 2
    Last Post: 07-13-2012, 04:02 AM
  6. extracting information from column to Another
    By walterw in forum Excel General
    Replies: 2
    Last Post: 06-27-2010, 05:28 PM
  7. Extracting Information from A Pivot Table
    By Jim Patterson in forum Excel General
    Replies: 2
    Last Post: 06-16-2006, 08:00 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