+ Reply to Thread
Results 1 to 3 of 3

Thread: Pasting list of text and numbers from MS Word

  1. 01-17-2010, 11:39 AM #1
    hongkongphooey
    hongkongphooey is offline
    Registered User
    Join Date
    01-17-2010
    Location
    Ireland
    MS-Off Ver
    Excel 2007
    Posts
    2

    Pasting list of text and numbers from MS Word

    Hi guys,

    I've searched quite a bit for an answer before asking, but here goes...

    I have a very large list of top scorers for a sports team MS Word. The name and number of goals are both on the same line.

    Is there any possible way I can past them into Excel, so as they are pasted into 2 separate columns?

    If I have not provided enough info, please say so.

    Thanks in advance.
    Last edited by hongkongphooey; 01-17-2010 at 11:54 AM.
    Reply With Quote Reply With Quote
  2. 01-17-2010, 11:43 AM #2
    shg
    shg is offline
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2007, 2010
    Posts
    25,770

    Re: Pasting list of text and numbers from MS Word

    You'd need to separate them with Data > Text to columns or a formula, depending on the format.
    Microsoft MVP - Excel
    Entia non sunt multiplicanda sine necessitate
    Reply With Quote Reply With Quote
  3. 01-17-2010, 11:54 AM #3
    hongkongphooey
    hongkongphooey is offline
    Registered User
    Join Date
    01-17-2010
    Location
    Ireland
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Pasting list of text and numbers from MS Word

    Quote Originally Posted by shg View Post
    You'd need to separate them with Data > Text to columns or a formula, depending on the format.
    Excellent.

    I'm only an occasional Excel user, so I was not aware of those functions.

    Much appreciated.
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0