View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Mike S[_5_] Mike S[_5_] is offline
external usenet poster
 
Posts: 86
Default Sort isn't working correctly

On 11/5/2016 10:44 PM, GARYWC wrote:
I specified that the extracted data be output to a comma-separated values (CSV) file. In Excel, I opened the CSV file by ticking "Delimited", unticking the "tab" delimiter and ticking the "comma" delimiter. Apparently, that "corrupted" the filenames so Excel couldn't sort the data correctly.

I re-extracted the data by specifying the data be output to a comma-separated values (CSV) file. In Excel, I opened the CSV file by again ticking "Delimited" but leaving the "tab" delimiter ticked. This time, the filenames did not become corrupted and Excel sorted the data correctly.


Thanks, glad you sorted it.