Case Sensitive Compare, Lookup, etc????
I'm a current Excel 2003 user and been frustrated with its in ability to do
comparisons on Ascii values correctly. I have come up with different hoop
jumping techniques but I'm getting old and tired.
Can anyone tell me if this issue has been resolved in 2007. I would upgrade
for that reason alone!
Example:
I need to discern the difference between 00Q3000000FHYdGEAX and
00Q3000000FHYDGEAX (upper and lower case "d" is the difference) in a
Vlookkup or compare, etc.
Thanks
|