Welcome Guest
Log In | Register )
You last visited December 7, 2016, 3:37 am
All times shown are
Eastern Time (GMT-5:00)

Can Excel do this?

Topic closed. 3 replies. Last post 9 years ago by Rakster.

Page 1 of 1
PrintE-mailLink
Rakster's avatar - praying hands.jpg
Saskatchewan
Canada
Member #19992
August 9, 2005
2867 Posts
Offline
Posted: May 3, 2008, 10:15 pm - IP Logged

I run the Pick 3 pirate... it generates 50 numbers, but when I cut them from the pirate and use it in a excel program I get the whole row of numbers (5 of them) instead of each number going to an individual cell.  is there a way I can change this so each number has its own cell rather than all 5 in one cell?

I know there are a lot of very smart excel users here and i have learned a lot from all of them, but I keep running into unique situations...lol

So instead of a string of 5 numbers in 1 cell I want it to show each of the 5 numbers in seperate cells... makes sense?  I just don't want to manually type in each number seperately. Anyone know how to change this or even if its possible to change it.

We are all Lucky... just some of us don't realize it!

    Todd's avatar - Cylon 2.gif
    Chief Bottle Washer
    New Jersey
    United States
    Member #1
    May 31, 2000
    23262 Posts
    Online
    Posted: May 4, 2008, 8:33 am - IP Logged

    Use a command in the Data menu called "Text to columns".  It presents a wizard to step through the process.  You tell it to either break on certain characters or on fixed character positions.

     

    Check the State Lottery Report Card
    What grade did your lottery earn?

     

    Sign the Petition for True Lottery Drawings
    Help eliminate computerized drawings!

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5387 Posts
      Offline
      Posted: May 4, 2008, 9:44 am - IP Logged

      Rakster,

      When you generate your combinations in the Pirate Program (Pick 3 or Pick 4)

      Just hightlight just the combinations.  Right click your mouse and select Copy.

      Open Excel and right-click your mouse and click Paste Special and select Text.

      Now all your picks should be in 5 separate columns.

      ========================================================

      If all your picks are in 1 row/column in Excel do the following:

      In Excel:

      In the Main Menu select > Data > Text To Columns > Deliminated

      In the Delimeters: Select > Tab > Space > Coma

      Click Finish

      All your combinations should be in 5 separate columns

        Rakster's avatar - praying hands.jpg
        Saskatchewan
        Canada
        Member #19992
        August 9, 2005
        2867 Posts
        Offline
        Posted: May 4, 2008, 10:08 am - IP Logged

        Thanks guys!!

        I really do appreciate your help!

        We are all Lucky... just some of us don't realize it!