+ Reply to Thread
Results 1 to 2 of 2

formatting columns

  1. #1
    Registered User
    Join Date
    02-06-2012
    Location
    Dublin
    MS-Off Ver
    Excel 2010
    Posts
    4

    formatting columns

    Hi,
    I am copying information into excel from a word doc. For some reason the information is not lining up correctly in excel when I paste it.
    2 questions!
    q1. is there a way to paste the information in so that the same information appears in the same column?

    1 Jon Do G Harriers M/Snr 19.1
    2 Rory H Engls Track Club M/Snr 20.03
    3 Jenny Fahy Olympic Houses M/Snr 20.25
    4 Labeta Dabela Limekeys A.C M/Snr 20.46

    thats an example of a piece of my results. i would just want
    1 Jon Do G Harriers M/Snr 19.1
    2 Rory C Ennis Track Club M/Snr 20.03
    3 Jenny Fahy Olympic Houses M/Snr 20.25
    4 Labeta Dabela Limekeys A.C M/Snr 20.46

    q2. if that cant be done, how can i highlight multiple columns and and merge the information into one column? eg.
    change
    col1 col2
    M/Snr
    M/Snr
    M/Snr
    M/Snr
    M/Snr
    M/Snr
    M/Snr
    M/35
    M/Snr
    M/Snr
    M/Jnr
    to
    col1 col2
    M/Snr
    M/Snr
    M/Snr
    M/Snr
    M/Snr
    M/Snr
    M/Snr
    M/35
    M/Snr
    M/Snr
    M/Jnr

    thanks

  2. #2
    Registered User
    Join Date
    02-06-2012
    Location
    Dublin
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: formatting columns

    sorry

    col1 col2
    M/Snr
    M/Snr
    M/Snr
    M/Snr
    M/Snr
    M/Snr
    M/Snr
    M/35
    M/Snr
    M/Snr
    M/Jnr
    to
    to
    col1 col2
    M/Snr
    M/Snr
    M/Snr
    M/Snr
    M/Snr
    M/Snr
    M/Snr
    M/35
    M/Snr
    M/Snr
    M/Jnr

    thanks

+ 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