+ Reply to Thread
Results 1 to 3 of 3

Only 2 columns, but 15k rows. All text. Best way to proceed...

  1. #1
    Registered User
    Join Date
    06-29-2010
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2007
    Posts
    1

    Angry Only 2 columns, but 15k rows. All text. Best way to proceed...

    Hi there...
    My experience with excel is limited, but I know I can easily search the forums or net for that information. My question is a bit beyond that..

    This is my situation. My friend was just given a whole new slew of karaoke music. He also got the file for the "book" for people to find songs to sing. The file was in Microsoft Works. Which is not only ugly, but I have to go to an older computer to open the works file. I have Microsoft Office 2007 and I rather use that. Using works I converted the file into a file that opens in excel. There is only 2 columns. Songs and Artists. And about 15,000 rows. And I need to add in a bunch more.

    Right now as a works file it prints two rows per page (artist, then song) and prints out on over 350 pages. What I want ideally is to print this list with 4 columns on each page so i can reduce the book by 1/2 the amount of pages needed. Now if this was indesign or quark design problems I wouldnt have issues. but this isn't.

    What do I do from here. Can i set up excel to be able to lay this out this way? Is there a way to send this to word and format it that way??

    I know I can save the file as a csv file and open that in word, but some of these songs and artists have commas in the names, so that just makes more columns.

    And on top of that excel doesnt seem to have a feature that i can convert all the text to all caps. I could try to fix the problems individually, but like i said, there is 15,000 rows (15,000 songs to choose from).

    Any idea how to get this format I want? And any way to make everything all caps?

    I just wish I could bring this into indesign easily and figure out how to do this, but I am lost.
    Last edited by keiko; 06-29-2010 at 03:51 AM.

  2. #2
    Registered User
    Join Date
    06-29-2010
    Location
    Indonesia
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Only 2 columns, but 15k rows. All text. Best way to proceed...

    Keiko,
    You can use "UPPER" formula to convert all the text to all caps, but sorry I don't have any idea how to print it in 4 columns. The easiest way I think is to cut half of your data row and place it to row 1 in the column 3 and 4.

  3. #3
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Only 2 columns, but 15k rows. All text. Best way to proceed...

    just use word copy the lot
    paste into word
    then in word use
    format/columns chose the number of columns you want
    then ctrl a to select all
    format/change case
    print from word
    this takes seconds to do
    by all means keep excel as your data base as its easier to sort
    but for printing use word everytime
    Last edited by martindwilson; 06-29-2010 at 05:54 AM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ 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