G Guest Mar 17, 2005 #1 I need to compare the first three characters of string1 to the first three characters of string2. How can I do this?
I need to compare the first three characters of string1 to the first three characters of string2. How can I do this?
F fredg Mar 17, 2005 #2 I need to compare the first three characters of string1 to the first three characters of string2. How can I do this? Click to expand... =IIf(Left(String1,3) = Left(String2,3),"Equal","Not Equal")
I need to compare the first three characters of string1 to the first three characters of string2. How can I do this? Click to expand... =IIf(Left(String1,3) = Left(String2,3),"Equal","Not Equal")
G Guest Mar 17, 2005 #3 Thanks a bunch! fredg said: =IIf(Left(String1,3) = Left(String2,3),"Equal","Not Equal") Click to expand...
Thanks a bunch! fredg said: =IIf(Left(String1,3) = Left(String2,3),"Equal","Not Equal") Click to expand...
