+ Reply to Thread
Results 1 to 5 of 5

Data importing from Text file to Excel

  1. #1
    Registered User
    Join Date
    12-05-2012
    Location
    delhi
    MS-Off Ver
    Excel 2010
    Posts
    2

    Data importing from Text file to Excel

    Hi all,

    I have a text file which is system generated. And I want to import the data from this text file to Excel in the manner as displayed in the screenshot of the excel ****. I want the Average of the number mentioned from Q3-06= X to Q3-10= X.

    But the problem is the I could not find the Average as its not purely a Numeric data, and also not sorted out like what I need.

    I need help to find these average numbers using any farmula or script. Pls help.

    Thanks a lot in Advance.

    (I have attached both Source file and the mentioned screenshot of excel sheet)
    Source file: EXCEL.jpg
    ScreenShot file: Sur.txt

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    Re: Data importing from Text file to Excel

    Welcome to the forum, you could provide a real xl workbook so the members could work for it. thanks.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    Re: Data importing from Text file to Excel

    change the range to suit.
    array formula ctrl+shift+enter ..not just enter ,you'll notice the curly braces around the formula when done right.

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Edit: Ok, understand
    Last edited by vlady; 12-05-2012 at 03:55 AM.

  4. #4
    Registered User
    Join Date
    12-05-2012
    Location
    delhi
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Data importing from Text file to Excel

    Quote Originally Posted by vlady View Post
    Welcome to the forum, you could provide a real xl workbook so the members could work for it. thanks.
    Hi vlady,

    First of all, Thanks for your response.

    Actually I have no processed excel file, as I do not know how can I import this data like how I shown you in screenshot. That screenshot is taken after arranging the data manually to demonstrate, what exactly I want to achieve.

    Let me know if you still want that xlsx file which I screenshotted.

    Millions of thanks in advance.

    regards,
    Yogesh

  5. #5
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    Re: Data importing from Text file to Excel

    here's your file with some notes.

    text to column.xlsm

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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