I have been asked to pars .ASC files to excel how do I do that?
B Bernard Liengme Sep 21, 2005 #2 What Lotus 123 used to call "parse", Excel calls Data|Text-to-Column Look under Help and come back if more needed best wishes
What Lotus 123 used to call "parse", Excel calls Data|Text-to-Column Look under Help and come back if more needed best wishes
G Gary''s Student Sep 21, 2005 #3 Import the file as text. Each record may end up in separate cells if the import wizard allows this to happen. If not the records will all end up in the cells in the first column. If this happens use Text to Columns... to parse the data.
Import the file as text. Each record may end up in separate cells if the import wizard allows this to happen. If not the records will all end up in the cells in the first column. If this happens use Text to Columns... to parse the data.