Forum Discussion

bluemanta's avatar
bluemanta
Copper Contributor
Apr 27, 2022

Error #Value! when using FIND ()

Hi All,

 

I'm trying to evaluate this formula: FIND (":",E35,1) but keep getting #Value! error if the cell E35 doesn't contain the ":"

This happens with any character that was not found in the string

 

What am I missing?

excel
Formulas and Functions

3 Replies

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Apr 27, 2022

    bluemanta 

    You did not read the online help text:

     

    If find_text does not appear in within_text, FIND and FINDB return the #VALUE! error value.

     

    • bluemanta's avatar
      bluemanta
      Copper Contributor
      Apr 27, 2022
      I did but it doesn't solve my problem 😉

      What is the alternative? workaround?
      • bluemanta's avatar
        bluemanta
        Copper Contributor
        Apr 27, 2022
        Nevermind, I found the solution:

        =IF(ISERROR(FIND(":",E38,1)),E38,"ABCD")