String Comparison

[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

 

[Peo Sjoblom]

=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

 

[Jason Morin]

With "apple" in A1 (no quotes):

=EXACT(A1,"apple")

equals TRUE.

=A1="apple"

also yields TRUE.

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi
=EXACT(C5,"some string")
should work

 

[Dan]

Watch Leading White Space in Cells with Text

-----Original Message-----
Hi
=EXACT(C5,"some string")
should work

--
Regards
Frank Kabel
Frankfurt, Germany


.