+ Reply to Thread
Results 1 to 2 of 2

Finding Text contained within Text with If function

  1. #1
    Registered User
    Join Date
    03-07-2018
    Location
    edinburgh, Scotland
    MS-Off Ver
    Office 365proplus
    Posts
    2

    Question Finding Text contained within Text with If function

    HI!
    trying to use IF ISNUMBER & SEARCH as per attached spreadsheet for pole types, however it keeps returning the false argument even when true?! please help thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Finding Text contained within Text with If function

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    You had comma which is not required =IF(ISNUMBER(SEARCH("Terminal",A3 , )), "Terminal H Pole", "dafty")
    Last edited by kev_; 03-23-2018 at 07:22 AM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

+ 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] Add 1 to a number contained in text.
    By Maroota in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-25-2017, 04:35 AM
  2. How to round a number off when contained in text
    By hasdrubal in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-05-2017, 12:02 AM
  3. [SOLVED] Looking for a formula that indicates text not contained in a list.
    By Travisty in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-20-2015, 09:58 AM
  4. Finding Contained Text within Multi-Faceted Formula
    By Nuggetross in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-26-2013, 04:49 PM
  5. [SOLVED] Return specific text if a different text is contained anywhere in a range of cells
    By ciayers in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2013, 05:54 PM
  6. [SOLVED] Countif function for instances of text string contained
    By Garbunkel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2005, 03:09 AM
  7. [SOLVED] RE: Countif function for instances of text string contained
    By David Billigmeier in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-10-2005, 05:05 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