Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Linking MS word to excel

  • 26-07-2005 9:39am
    #1
    Zena
    Registered Users, Registered Users 2 Posts: 62 ✭✭


    Hi,

    I have a list of names/addresses in MS word, but I want to import the info into a neat table in excel, does anyone know if I can do this?

    I would like to avoid copying the info individually - coz it will take me ages :rolleyes:
    Thanks


Comments

  • #2
    BaZmO*
    Registered Users, Registered Users 2 Posts: 18,625 ✭✭✭✭BaZmO*


    I don't really get what you want to do. Why can't you just select all, copy and then paste into excel?

    B.


  • #3
    Zena
    Registered Users, Registered Users 2 Posts: 62 ✭✭Zena


    I want the name and address etc to appear in different columns, not all in one cell.
    I


  • #4
    BaZmO*
    Registered Users, Registered Users 2 Posts: 18,625 ✭✭✭✭BaZmO*


    I think I know what you mean now.

    Select all
    Copy
    Right click in the cells in excel
    Choose one of the options to paste
    Try the different options until you get the one you want

    That's the best bit of advice I can give cos I don't now what way you have the info formatted in Word.

    B.


  • #5
    celtic2004
    Closed Accounts Posts: 2 ✭celtic2004


    Copy the info in from word.

    In excel, highlight your column go to 'Data' -> 'Text to columns' and you can divide up your data into the columns.


Advertisement