+ Reply to Thread
Results 1 to 3 of 3

=ISNUMBER(SEARCH(" screen ", " "&X2&" "))

  1. #1
    Registered User
    Join Date
    01-30-2020
    Location
    Dublin, Ireland
    MS-Off Ver
    Microsoft Office 365 Consumer Subscription 2018
    Posts
    4

    =ISNUMBER(SEARCH(" screen ", " "&X2&" "))

    I am trying to find certain texts using this formula =ISNUMBER(SEARCH(" screen ", " "&X2&" ")). It works but only on one particular cell, i.e. X2.
    I need to search from A2:X2, how do I do this PLEASE and THANK YOU!

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello lorrainekelly,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    09-15-2019
    Location
    Gurgaon, India
    MS-Off Ver
    2003 2007 2010
    Posts
    8

    Re: =ISNUMBER(SEARCH(" screen ", " "&X2&" "))

    Hello

    It is not good to post your question here, maybe here is better 4 U ..
    https://www.excelforum.com/excel-programming-vba-macros/

    2 here post is just to say "Hello"

    Hello..Introduce yourself
    A place for us to get to know each other better, especially the new members who join the forum. If you wish to post a question, please choose the relevant sub-forum here https://www.excelforum.com/excel-programming-vba-macros/

    Last edited by DevelopmentTest; 01-30-2020 at 09:07 AM.

+ 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: 5
    Last Post: 02-05-2019, 12:03 AM
  2. Replies: 2
    Last Post: 07-24-2017, 02:19 AM
  3. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  4. 7 nested IF statements with a SEARCH added IF(ISNUMBER(SEARCH({"INSUR","AP REFUND"}
    By michaelproctor001 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 12-10-2013, 02:13 PM
  5. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  6. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  7. Replies: 6
    Last Post: 02-25-2013, 03:16 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