ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I pars in excel (https://www.excelbanter.com/excel-discussion-misc-queries/46521-how-do-i-pars-excel.html)

kfe80598

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

Bernard Liengme

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?




Gary''s Student

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?



All times are GMT +1. The time now is 03:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com