Hi,
When performing sorts and lookups (vlookup etc) Excel 2013 seems to only consider the first 255 characters of long strings. The real problem is that it does the sort incorrectly and does not give any warning! It does do equality comparisons correctly.
This is a problem for me because I manipulate DNA & protein sequences in Excel and it is common for the first 255 characters to be the same, but then for sequences to diverge.


I don't have a real problem with Excel not doing this sort correctly, it really isn't designed for this sort of use, but I do have a problem with not giving a warning as it is giving objectively incorrect results!
Ethan