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

  • lorraine@promotionalgoods.ie
  • lorraine@promotionalgoods.ie's Avatar Topic Author
  • Offline
6 months 1 week ago #2045 by lorraine@promotionalgoods.ie
=ISNUMBER(SEARCH(" screen ", " "&X2&" ")) was created by lorraine@promotionalgoods.ie
I am trying to find certain text 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!

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun