FIND function

  • Thread starter Thread starter Jeff Klein
  • Start date Start date
J

Jeff Klein

I am using the "find" function to locate a particular letter in a cell.
This works fine except when the letter does not exist in the cell.
Displayed in the cell is "#VALUE!" and is not useable.

Is there a way to
=if(find("G",A1,1) = "nothing found",A1,find("G",A1,1))
 
=if(iserror(find("G",a1,1)),"nothing found",find("G",a1,1))

will return either the string "nothing found" or the position of the first G in
A1.

You could also use =isnumber()

=if(isnumber(find(...)),"found it","not found")
 
Is there a way to
=if(find("G",A1,1) = "nothing found",A1,find("G",A1,1))
Click to expand...

Another one:

I assume you are looking specifically for the uppercase "G".

=IF(COUNT(FIND("G",A1)),FIND("G",A1),"Nothing Found")

I see that you're using the [start_num] argument to FIND. If you want to
look at the *entire* string you can just omit the [start_num] argument. If
you're using it thinking it *only* looks at the first character of the
string and that's what you want:

=IF(EXACT(LEFT(A1),"G"),1,"Nothing Found")
 
Back
Top