1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Need help with Excel spreadsheet

Discussion in 'Business Applications' started by davebozy, Sep 11, 2011.

Thread Status:
Not open for further replies.
Advertisement
  1. davebozy

    davebozy Thread Starter

    Joined:
    Aug 25, 2011
    Messages:
    4
    Attached is a spreadsheet I have 2 questions on. I have read many posts out here but I haven't gotten any to work.

    1. How do I remove the page # that appears on each page?
    2. Is it possible to sort the contents of a single cell? I want to sort the following data that is in a single cell: Magellan, PrimeSource-GSH, UBH, Quest, Value Options, Intergroup, Cigna, CBHNP, CCBHO, Gateway Assured, Aetna, Highmark, Premier Blue, Freedom Blue, Unison, MH Net, LifeSynch, LifeSynch MC, Medicare

    Any help would be much appreciated.
     

    Attached Files:

  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,180
    First Name:
    Wayne
    you have it in print view
    goto the menu across the top and find the item "view" click on that and then
    select normal
    the page numbers will disappear

    Not sure how to sort the cell data - i would do a Text to columns and then copy , paste special and transpose , then sort that data , and then use concatenate to bring all backinto 1 cell - which is quite a long winded way
     
  3. davebozy

    davebozy Thread Starter

    Joined:
    Aug 25, 2011
    Messages:
    4
    thank you for the reply. When I copy and paste transpose - I get an error - The selection is not valid.
     
  4. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,180
    First Name:
    Wayne
    i have down i cell A4 and then shown the steps
     

    Attached Files:

  5. davebozy

    davebozy Thread Starter

    Joined:
    Aug 25, 2011
    Messages:
    4
    I see - How do I get them all back into a single sell?
     
  6. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,180
    First Name:
    Wayne
    its in the sample - concatenate &
    so G1&", "G2&", "G3&", "G4
    etc
     
  7. davebozy

    davebozy Thread Starter

    Joined:
    Aug 25, 2011
    Messages:
    4
    Thanks for your help, I found that the secretary can retype all the data quicker than I can do this. So I conceeded to manual labor this time but I will contine to research and learn to use Excel.
     
  8. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1017098

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice