Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing String Values
You can make all string comparisons in a given module case insensitive by
adding: Option Compare Text at the top. Otherwise you can use: lcase(str1) = lcase(str2) or StrComp(str1,str1, vbTextCompare) -- Jim Rech Excel MVP "Ben H" wrote in message ... | Spot on, Gentlemen! Thanks! | | Now about the follow! | Is there a way to make it to return true when comparing, "J45006" to | "j45006"? | | Thanks! | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing the first 2 characters of a coloumn to a string | Excel Worksheet Functions | |||
Help with Comparing values and retrieving values in Excel!!!!!! | Excel Worksheet Functions | |||
Comparing String Values | Excel Programming | |||
Comparing String Values | Excel Programming | |||
Question about comparing mixed case string values | Excel Programming |