WordPad file convert in Excel

Discussion in 'Microsoft Excel Misc' started by Guest, Apr 21, 2006.

  1. Guest

    Guest Guest

    My company is using a system for sale tracking. The report output is
    generated in WordPad file. I have lot of problem to convert WordPad file to
    convert in Excel on daily basis for different reports.
    Can It possible for just few little time to convert WordPad file into Excel
    for Analysis and Pivot Report.
     
    Guest, Apr 21, 2006
    #1
    1. Advertisements

  2. Guest

    Bryan Hessey Guest

    Normally one would use Data, Import External Data, Import Data, identify
    the file, identify the delimiters and whether consecutive delimiters are
    considered = 1, set the date format as required, and import.

    This, of course, depends how your data was output to you, and how you
    want it to be used, that is, the Format of the data you receive.

    With no other details the time taken could be any length.

    Hope this helps.

    --

    Tarique Wrote:
    > My company is using a system for sale tracking. The report output is
    > generated in WordPad file. I have lot of problem to convert WordPad
    > file to
    > convert in Excel on daily basis for different reports.
    > Can It possible for just few little time to convert WordPad file into
    > Excel
    > for Analysis and Pivot Report.



    --
    Bryan Hessey
    ------------------------------------------------------------------------
    Bryan Hessey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21059
    View this thread: http://www.excelforum.com/showthread.php?threadid=534942
     
    Bryan Hessey, Apr 21, 2006
    #2
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Dave Peterson

    Re: copying data from wordpad to excel

    Dave Peterson, Sep 4, 2004, in forum: Microsoft Excel Misc
    Replies:
    0
    Views:
    619
    Dave Peterson
    Sep 4, 2004
  2. Guest
    Replies:
    2
    Views:
    181
    Jim Rech
    Oct 1, 2005
  3. Guest

    connecting wordpad and excel

    Guest, May 4, 2007, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    803
    Roger Govier
    May 4, 2007
  4. DaveM

    Paste Data To WordPad TXT File

    DaveM, Dec 26, 2007, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    171
    Chip Pearson
    Dec 26, 2007
  5. SharonR

    Exel file opens in Wordpad

    SharonR, Dec 1, 2008, in forum: Microsoft Excel Misc
    Replies:
    4
    Views:
    253
    SharonR
    Dec 2, 2008
Loading...

Share This Page