| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Matching Case
How can I test a text value in a cell when CAPITALIZATION DOES NOT EQUAL
LOWER CASE??? In other words, "MIAMI" and "Miami" is NOT a match. Thanks, FLKulchar |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Matching Case
Are you asking how to make the formula disregard the case of the text when it
compares? "F. Lawrence Kulchar" wrote: How can I test a text value in a cell when CAPITALIZATION DOES NOT EQUAL LOWER CASE??? In other words, "MIAMI" and "Miami" is NOT a match. Thanks, FLKulchar |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Matching Case
"F. Lawrence Kulchar" wrote in
message ... How can I test a text value in a cell when CAPITALIZATION DOES NOT EQUAL LOWER CASE??? In other words, "MIAMI" and "Miami" is NOT a match. and it should be? It's not clear from your question what the desired outcome of that comparison would be. If you want to ignore the case then If UCase(someVar) = "MIAMI" then 'stuff End if Tim |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Matching Case
On Sun, 24 Sep 2006 17:39:01 -0700, F. Lawrence Kulchar
wrote: How can I test a text value in a cell when CAPITALIZATION DOES NOT EQUAL LOWER CASE??? In other words, "MIAMI" and "Miami" is NOT a match. Thanks, FLKulchar In VBA, with the default Option Compare Binary, you can use the "Like" operator. In Excel, you can use the EXACT worksheet function. --ron |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Matching Case
i am not using macros or VBA...only the EXCEL formulas.
"Ron Rosenfeld" wrote in message ... On Sun, 24 Sep 2006 17:39:01 -0700, F. Lawrence Kulchar wrote: How can I test a text value in a cell when CAPITALIZATION DOES NOT EQUAL LOWER CASE??? In other words, "MIAMI" and "Miami" is NOT a match. Thanks, FLKulchar In VBA, with the default Option Compare Binary, you can use the "Like" operator. In Excel, you can use the EXACT worksheet function. --ron |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Matching Case
Ron wasn't kidding.
Look at excel's help for =exact(). FLKulchar wrote: i am not using macros or VBA...only the EXCEL formulas. "Ron Rosenfeld" wrote in message ... On Sun, 24 Sep 2006 17:39:01 -0700, F. Lawrence Kulchar wrote: How can I test a text value in a cell when CAPITALIZATION DOES NOT EQUAL LOWER CASE??? In other words, "MIAMI" and "Miami" is NOT a match. Thanks, FLKulchar In VBA, with the default Option Compare Binary, you can use the "Like" operator. In Excel, you can use the EXACT worksheet function. --ron -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Matching Case
EUREKA...=IF(Exact(A1,B1),"YES","NO")
"FLKulchar" wrote in message ... i am not using macros or VBA...only the EXCEL formulas. "Ron Rosenfeld" wrote in message ... On Sun, 24 Sep 2006 17:39:01 -0700, F. Lawrence Kulchar wrote: How can I test a text value in a cell when CAPITALIZATION DOES NOT EQUAL LOWER CASE??? In other words, "MIAMI" and "Miami" is NOT a match. Thanks, FLKulchar In VBA, with the default Option Compare Binary, you can use the "Like" operator. In Excel, you can use the EXACT worksheet function. --ron |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Matching Case
On Sun, 24 Sep 2006 21:03:40 -0400, "FLKulchar"
wrote: i am not using macros or VBA...only the EXCEL formulas. As I wrote: "In Excel, you can use the EXACT worksheet function." Did you check that out? --ron |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Matching Case
yes...all is great
"Ron Rosenfeld" wrote in message ... On Sun, 24 Sep 2006 21:03:40 -0400, "FLKulchar" wrote: i am not using macros or VBA...only the EXCEL formulas. As I wrote: "In Excel, you can use the EXACT worksheet function." Did you check that out? --ron |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Matching Case
Okay..I understand the =EXACT(a1,b1) function...but how can i test using the
=IF function. i.e. =IF(A1=B1, "YES","NO") And I desire an EXACT match...so A1 < B1 if "MIAMI" and "Miami" are within the cells!! How to use th =IF function?? Thanks, FLKLulchar "Ron Rosenfeld" wrote in message ... On Sun, 24 Sep 2006 17:39:01 -0700, F. Lawrence Kulchar wrote: How can I test a text value in a cell when CAPITALIZATION DOES NOT EQUAL LOWER CASE??? In other words, "MIAMI" and "Miami" is NOT a match. Thanks, FLKulchar In VBA, with the default Option Compare Binary, you can use the "Like" operator. In Excel, you can use the EXACT worksheet function. --ron |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Matching Case
=IF(EXACT(A1,B1),"yes","no")
FLKulchar wrote: Okay..I understand the =EXACT(a1,b1) function...but how can i test using the =IF function. i.e. =IF(A1=B1, "YES","NO") And I desire an EXACT match...so A1 < B1 if "MIAMI" and "Miami" are within the cells!! How to use th =IF function?? Thanks, FLKLulchar "Ron Rosenfeld" wrote in message ... On Sun, 24 Sep 2006 17:39:01 -0700, F. Lawrence Kulchar wrote: How can I test a text value in a cell when CAPITALIZATION DOES NOT EQUAL LOWER CASE??? In other words, "MIAMI" and "Miami" is NOT a match. Thanks, FLKulchar In VBA, with the default Option Compare Binary, you can use the "Like" operator. In Excel, you can use the EXACT worksheet function. --ron -- Dave Peterson |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Matching Case
I see it now...thank you..all is okay
flkulchar "Dave Peterson" wrote in message ... =IF(EXACT(A1,B1),"yes","no") FLKulchar wrote: Okay..I understand the =EXACT(a1,b1) function...but how can i test using the =IF function. i.e. =IF(A1=B1, "YES","NO") And I desire an EXACT match...so A1 < B1 if "MIAMI" and "Miami" are within the cells!! How to use th =IF function?? Thanks, FLKLulchar "Ron Rosenfeld" wrote in message ... On Sun, 24 Sep 2006 17:39:01 -0700, F. Lawrence Kulchar wrote: How can I test a text value in a cell when CAPITALIZATION DOES NOT EQUAL LOWER CASE??? In other words, "MIAMI" and "Miami" is NOT a match. Thanks, FLKulchar In VBA, with the default Option Compare Binary, you can use the "Like" operator. In Excel, you can use the EXACT worksheet function. --ron -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change data of entire column from small case to upper case | Excel Worksheet Functions | |||
| Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
| excel'03 how to convert a column from upper case to proper case | Excel Discussion (Misc queries) | |||
| Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
| How to use formula auditing to change upper case to Title Case. | Excel Worksheet Functions | |||
Hybrid Mode
