+ Reply to Thread
Results 1 to 3 of 3

Can I create an Excel IF Function with Partial Text Match that results whole in the Text i

  1. #1
    Registered User
    Join Date
    07-13-2020
    Location
    Francistown, Botswana
    MS-Off Ver
    2016
    Posts
    1

    Can I create an Excel IF Function with Partial Text Match that results whole in the Text i

    I have a column with different information in it. I can use.
    In this example I will be referencing A17.
    =IF(ISNUMBER(SEARCH("front", A17)), "Front", "") to get the text "Front" in the cell
    My question is, is it possible to do a similar IF function so search for "HUB" but not just paste "HUB". But instead paste the full HUB328 =IF(ISNUMBER(SEARCH("Hub", A17)), "XXXX", "") .
    I want a function that i can use and drag down. For A17 it results in "HUB328". For A18 it results in "HUB329" etc.
    I manually put the information in Column H.
    I have downloaded Kutools but am still having a hard time navigating it
    Thank you
    Attached Images Attached Images
    Last edited by spqr-123; 07-13-2020 at 08:39 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    578

    Re: Can I create an Excel IF Function with Partial Text Match that results whole in the Te

    if the following number is always 3 digits - you could use MID - the Search being the starting position

  3. #3
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,006

    Re: Can I create an Excel IF Function with Partial Text Match that results whole in the Te

    Try this: ="HUB"&MID(A17,SEARCH("HUB",A17)+LEN("HUB"),SEARCH(" ",A17)-SEARCH("HUB",A17)-LEN("HUB"))
    Otherwise, follow the instructions found in the yellow banner above.
    Click the * to say 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] Index match 2 items returning multiple results & search for partial text
    By billrogers184 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2020, 01:45 PM
  2. [SOLVED] Please help on COUNTIF Partial text, partial text/words also contained in other texts
    By maria.h in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-15-2020, 10:18 PM
  3. Search and Match partial text string to full text and return a value
    By homa5424 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-09-2017, 10:52 AM
  4. [SOLVED] Function that will search partial text match and place a 1 in column
    By thebrin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2017, 01:38 AM
  5. Excel Vlookup with Partial Text Match
    By Fasihuddin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-26-2016, 12:21 PM
  6. [SOLVED] Match partial text when partial text is not exact
    By NamiSama in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-21-2014, 07:18 PM
  7. Excel 2007 : Results Cells equals Partial Text
    By donkeylarry in forum Excel General
    Replies: 3
    Last Post: 02-08-2012, 05:12 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