Importing Text File into Excel

G

Guest

How to I programme the excel such that it will automatically import all the
Text file generated from the measuring equipment and arrange them in a
particular format that I want.?
 
P

Pete_UK

If your text file has a filename with an extension .txt, then start
Excel and do File | Open with "All files (*.*)" selected as the file
type - identify your file and click open. Excel will automatically take
you into the Text Import Wizard, which has 3 stages:

Stage 1: specify if fixed-width or delimited
Stage 2: specify the character used as delimiter
Stage 3: specify the data type for each column

When you click <finish>, the file will be loaded into Excel.

You should practice this a few times, then you could record a macro
while you do it, so that in future you would only need to invoke the
macro to do it for you automatically.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top