View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beverly Blake Beverly Blake is offline
external usenet poster
 
Posts: 1
Default create a ASCII semi-colon or comma delimited file

I need to create a ASCII semi-colon or comma delimited file. The text in the
file need to appear as follows:

€œ4400112453€;€James€;€E€;€Smith€; €111121111€;03/10/1962;7/01/1999;6/30/2003;4;€05404€;1998

I can save the text file with the semicolons or commas as delimiters;
however I cannot get both. I am working with a Excel 2003