Notepad to Excel??

Discussion in 'Databases' started by gemini181, Jul 18, 2007.

0
  1. #1
    In Notepad:

    name 1
    name 2
    name 3
    .
    .
    .
    .
    name 95
    name 96 (for example)
    ~~~~~~~~~~~~~~~

    Can I import this into ms office excel or do I need to copy / paste each name?
    Anyone know exactly how?

    Thanks

    ~~
    (Office 2007 has changed a lot, since ~2002)
    I'm lost even on stuff I used to be really good at :eek:
    ~~
    ~~~~
    Edit: I though copy / paste (from Notepad) would put the whole list in just one cell, but it worked

    [​IMG]
     
    gemini181, Jul 18, 2007 IP
  2. coldfire7

    coldfire7 Peon

    Messages:
    504
    Likes Received:
    30
    Best Answers:
    0
    Trophy Points:
    0
    #2
    i may assume that ur qurey is solved now ......although its a simple copy/paste....if not or whatever case u have u can copy the list and goto excel and use "PasteSpecial" in a way u want to paste :)
     
    coldfire7, Jul 19, 2007 IP