+ Reply to Thread
Results 1 to 2 of 2

Finding specific word in a cell

  1. #1
    Registered User
    Join Date
    04-05-2012
    Location
    KP
    MS-Off Ver
    Excel 2016
    Posts
    67

    Finding specific word in a cell

    Hi,
    I have a list of titles in Column A. For example

    UMI Performance 1979-1993 Ford Mustang Lower Front Reinforcements
    UMI Performance 1979-1993 Ford Mustang Rear Lower Control Arm Reinforcements
    UMI Performance 94-04 Ford Mustang Upper and Lower Control Arm Reinforcements

    In Column B i would like to see which titles have word "Front" in it.

    Thanks a lot

  2. #2
    Registered User
    Join Date
    04-05-2012
    Location
    KP
    MS-Off Ver
    Excel 2016
    Posts
    67

    Re: Finding specific word in a cell

    I found a solution through google search.
    The formula is "=ISNUMBER(SEARCH("front",B2))

    Thanks

+ 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] Trouble finding specific word in text
    By Bas van den Boomen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-20-2019, 03:14 PM
  2. Replies: 12
    Last Post: 06-12-2014, 02:11 PM
  3. [SOLVED] Macro for finding specific Word and Deleting it
    By Haidar123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-02-2014, 07:45 AM
  4. Macro to change colour of cell based on finding a specific word in the cell
    By Shelby761 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2014, 09:46 AM
  5. Finding a specific word within cell
    By Vespasian in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 01-26-2013, 05:57 AM
  6. Finding a specific word in a cell and executing an array
    By jgray152 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-10-2010, 07:49 PM
  7. [SOLVED] Finding specific word in column
    By Phil #3 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-28-2005, 04:06 AM

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