+ Reply to Thread
Results 1 to 3 of 3

How do I transfer data from Notepad to Excel?

  1. #1
    erika
    Guest

    How do I transfer data from Notepad to Excel?

    I transferred a file from a database that will only save reports in Notepad.
    I then, cut and paste the data into Excel. However all of the info is merged
    into one cell. How can I format this data, so that it will be a simple
    worksheet with more than one cell? i.e. Name, SSN, Home address should all be
    in different cells

  2. #2
    Gord Dibben
    Guest

    Re: How do I transfer data from Notepad to Excel?

    Erika

    After the fact you could use the Data>Text to Columns feature to parse the
    data.

    OR....

    Don't cut and paste from the Notepad.txt file.

    In Excel go to File>Open. Select the Notepad.txt file and OK.

    The Excel Text Import Wizard will open and you parse the data there.


    Gord Dibben Excel MVP

    On Tue, 18 Jan 2005 11:39:11 -0800, "erika" <[email protected]>
    wrote:

    >I transferred a file from a database that will only save reports in Notepad.
    >I then, cut and paste the data into Excel. However all of the info is merged
    >into one cell. How can I format this data, so that it will be a simple
    >worksheet with more than one cell? i.e. Name, SSN, Home address should all be
    >in different cells



  3. #3
    Spiff
    Guest

    RE: How do I transfer data from Notepad to Excel?

    Erika,

    Have you tried importing the file through the Data | Import External Data |
    Import Data... function? This function will allow you to import the data and
    separate the fields into different cells.

    Henry Falk

    "erika" wrote:

    > I transferred a file from a database that will only save reports in Notepad.
    > I then, cut and paste the data into Excel. However all of the info is merged
    > into one cell. How can I format this data, so that it will be a simple
    > worksheet with more than one cell? i.e. Name, SSN, Home address should all be
    > in different cells


+ 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