| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two cells look identical but give false response to "Exact".
I am trying to compare two columns of data. Col A is emailed data; Col C is
cut and pasted from website. All 400 of Col C is in Col A, but only 80 show as Match. They look and LEN the same, but Exact is false in all but the 80. I can't modify Col C to complete Match unless I can figure out what's wrong with cells in Col C. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable autoformat of "true" and "false" text | Excel Discussion (Misc queries) | |||
| My exact "text" statement is returning a value of 0 for false?? | Excel Discussion (Misc queries) | |||
| Formatting "IF" response based on "OR" function | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Threaded Mode
