+ Reply to Thread
Results 1 to 5 of 5

How do I turn text files into Excell spreadsheets?

  1. #1
    Registered User
    Join Date
    04-29-2017
    Location
    Colchester, Essex
    MS-Off Ver
    excell 2010
    Posts
    3

    How do I turn text files into Excell spreadsheets?

    Hi Guys/Girls,
    I am more of a mechanic than an IT guru. I am dealing with an aircraft that has EFIS (Electronic Flight Info' System) that records data in .ALD files. I download these files via a data stick in .ald format, then open them in M'soft notepad. This I then import into Excell, but it's a mess. Can anyone help please?
    I am trying to get from this:
    Text file.jpg
    To this:
    Exell 1.jpg
    To this:
    Excell.jpg
    Thank you for your time.
    Neil
    Last edited by NeilSpooner; 04-29-2017 at 05:46 AM.

  2. #2
    Registered User
    Join Date
    04-29-2017
    Location
    Colchester, Essex
    MS-Off Ver
    excell 2010
    Posts
    3

    Re: How do I turn text files into Excell spreadsheets?

    ....ok, cracked it....I need to change the .ALD file extension to .txt, and work through that way.....sorry to have troubled you.
    Neil

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    5,808

    Re: How do I turn text files into Excell spreadsheets?

    can you attach a sample of the file here ?
    it looks like a CSV comma separated file
    but how it will import depends on that format - I dont see a Date in the text shown
    when you open in notepad
    use save as
    then change the file name from .TXT to .CSV
    open in excel and it should import

    OR you can do Text to Columns in excel and use delimited and ,
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,076

    Re: How do I turn text files into Excell spreadsheets?

    Hello NeilSpooner,

    Well done.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Thanks.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  5. #5
    Registered User
    Join Date
    04-29-2017
    Location
    Colchester, Essex
    MS-Off Ver
    excell 2010
    Posts
    3

    Re: How do I turn text files into Excell spreadsheets?


    Thanks for your help.
    Neil

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. can we turn our spreadsheets into a distributable application?
    By RustyNail in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2015, 07:59 PM
  2. IMPORTING TEXT FILES TO EXCELL - Multiple Multi line text files
    By Toxicca in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-12-2014, 09:56 AM
  3. Copy data between 2 excell spreadsheets
    By omer123456 in forum Excel General
    Replies: 2
    Last Post: 11-29-2011, 08:18 PM
  4. Replies: 3
    Last Post: 04-13-2009, 12:28 PM
  5. Excell will run as normal but won't open any spreadsheets
    By Brendan.Lawton in forum Excel General
    Replies: 1
    Last Post: 08-05-2008, 06:10 AM
  6. create a slides show with excell spreadsheets using excell
    By wantabepas in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-16-2006, 02:50 PM
  7. multiple spreadsheets in Excell
    By Mhn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-26-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1