+ Reply to Thread
Results 1 to 5 of 5

extract specific word from a description to a specific column

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,079

    extract specific word from a description to a specific column

    I have a data sheet in column B where I need to extract specific word SADC in column B to columns E

    Looking a formula to extract the word sadc from column B to E
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,513

    Re: extract specific word from a description to a specific column

    This should do it...

    =IF(ISNUMBER(SEARCH("SADC",B2)),"SADC","")
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

  3. #3
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: extract specific word from a description to a specific column

    Under the Data Ribbon, there's an "Advanced Filter" option. I am only giving you an example with a screenshot in the file of the criteria I used. It should be self-explanatory, you can mimic the logic and apply to your use case. Just make sure your column header names are all unique.
    Attached Files Attached Files

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,473

    Re: extract specific word from a description to a specific column

    I'm not sure what you mean by extract?
    Replace SADC?
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    If you want to see if something has SADC then
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: extract specific word from a description to a specific column

    Try this
    Enter in E2 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ 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: 9
    Last Post: 06-09-2016, 10:28 AM
  2. Need to extract specific but varying length and location numbers from description
    By 5bigun in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2016, 10:39 AM
  3. [SOLVED] If a specific row contains a word, then clear specific content in corresponding column.
    By johansoder in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-18-2014, 05:38 PM
  4. Move row data to a specific sheet if column contains specific word
    By Kennethc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2014, 06:55 PM
  5. Extract specific column data from specific sheet from multiple files in a folder
    By piggyfox in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-31-2013, 11:51 AM
  6. A Sum If one column is a specific description it changes the value.
    By italianstallion in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-02-2013, 03:26 AM
  7. Extract a value if a specific word is in the next column
    By cjkcoupon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-15-2011, 02:28 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