View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GSkerm GSkerm is offline
external usenet poster
 
Posts: 2
Default 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