Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
kfe80598
 
Posts: n/a
Default How do I pars in excel

I have been asked to pars .ASC files to excel how do I do that?
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

What Lotus 123 used to call "parse", Excel calls Data|Text-to-Column
Look under Help and come back if more needed
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"kfe80598" wrote in message
...
I have been asked to pars .ASC files to excel how do I do that?



  #3   Report Post  
Gary''s Student
 
Posts: n/a
Default

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.
--
Gary''s Student


"kfe80598" wrote:

I have been asked to pars .ASC files to excel how do I do that?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) Alain79 Excel Discussion (Misc queries) 4 June 14th 05 07:34 AM
Stop Excel Rounding Dates leinad512 Excel Discussion (Misc queries) 1 April 20th 05 04:19 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
Excel error - Startup (and Acrobat PDFMaker) gxdata Setting up and Configuration of Excel 0 February 4th 05 03:44 AM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM


All times are GMT +1. The time now is 06:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"