View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Laverty Bob Laverty is offline
external usenet poster
 
Posts: 1
Default Text string sort limit

I concatentated several columns of data to use as a vlookup match key between
some database query results and some existing spreadsheet data. The
concatenated string is all numeric, 27 characters long, but formatted as
text. The Excel 2003 sort appears to have a limit to the number of
characters it will sort as a text string. Is this issue documented anywhere?