String Comparison

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Is it possible to compare a string in a cell against a
specified string; similar to c5="somestring" ?? Is there
any variable conversion necessary?? The EXACT function
only seems to compare two cell values, but will not
correctly compare against a specified input.
Thanks
 
=ISNUMBER(FIND("somestring",C5))

if you are talking about comparing if C5 contains a specific string
regardless
if it is only a part of C5
 
With "apple" in A1 (no quotes):

=EXACT(A1,"apple")

equals TRUE.

=A1="apple"

also yields TRUE.

HTH
Jason
Atlanta, GA
 
Back
Top