+ Reply to Thread
Results 1 to 3 of 3

Have excel show word match instead of partial match

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Have excel show word match instead of partial match

    Hi guys

    I have a sheet with a long list of words and output from another source

    I need help to have excel show me anything I need to pay particular attention to.

    SO in column A, I have the word unt but in column H, I have text as part of sentences such as bunting, hunt etc.

    I want a conditional formatting that says in column A, anything with a full word match to the phrase in column H should be highlighted. There are no full word matches in my example but I am future proofing this.

    Please help and advise thank you!
    Attached Files Attached Files
    Thanks,

    R.



  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Have excel show word match instead of partial match

    Try to find independent word " unt " (between two spaces)

    =ISNUMBER(SEARCH(" "&B1&" ",H1))
    Quang PT

  3. #3
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Re: Have excel show word match instead of partial match

    thank you!

+ 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] Nesting if statements when a partial word match is found
    By knakw00 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2018, 03:27 PM
  2. [SOLVED] Conditional formating of rows when partial word match in E and non-blank in P
    By Xsample in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-06-2018, 10:28 AM
  3. Match partial word instead of all or nothing
    By Geralt86 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-02-2017, 01:58 PM
  4. VBA: Find all sentences with a given word. Partial match preferred with regex.
    By first_jaguar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2017, 02:26 PM
  5. Copy column based on partial word match in first row and paste into existing workbook
    By David Harris 1987 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2013, 01:02 PM
  6. Replies: 4
    Last Post: 04-26-2011, 04:38 PM
  7. Using CountIf to show Partial Match Value?
    By Jaricketts in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2010, 03:56 PM

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