+ 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
    West Sussex, UK
    MS-Off Ver
    365 for Mac
    Posts
    5,390

    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 a reputation icon * 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,065

    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)

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