How do I transfer data from Notepad to Excel?

Discussion in 'Microsoft Excel Misc' started by Guest, Jan 18, 2005.

  1. Guest

    Guest Guest

    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
     
    Guest, Jan 18, 2005
    #1
    1. Advertisements

  2. Guest

    Gord Dibben Guest

    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" <>
    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
     
    Gord Dibben, Jan 18, 2005
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    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
     
    Guest, Jan 18, 2005
    #3
  4. Guest

    ryan.anderson887

    Joined:
    May 25, 2012
    Likes Received:
    0
    i have created an account with pcreview how do i import leads from notepad to excel
     
    ryan.anderson887, May 25, 2012
    #4
    1. Advertisements

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Cindi Schneider

    Import data from Notepad to Excel

    Cindi Schneider, Aug 27, 2003, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    3,991
  2. Guest
    Replies:
    3
    Views:
    8,399
    Dave Peterson
    Feb 12, 2005
  3. Guest
    Replies:
    1
    Views:
    382
    Guest
    Feb 10, 2005
  4. Guest
    Replies:
    1
    Views:
    382
    Peo Sjoblom
    Feb 10, 2005
  5. Guest
    Replies:
    1
    Views:
    633
    Peo Sjoblom
    Feb 10, 2005
  6. Guest
    Replies:
    0
    Views:
    334
    Guest
    Apr 18, 2005
  7. Guest
    Replies:
    0
    Views:
    307
    Guest
    Jul 13, 2007
  8. tcmh
    Replies:
    1
    Views:
    1,128
    JLatham
    May 3, 2009
Loading...