View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jheby
 
Posts: n/a
Default hash function for large strings

Excel vlookup function returns #VALUE when the lookup value exceeds 256
characters. I need a hash function to transform large strings into a value
that does not exceed the 256 character limit. Are there any quick solutions
to this problem?