Welcome Guest
Log In | Register )
You last visited December 2, 2016, 2:44 pm
All times shown are
Eastern Time (GMT-5:00)

Can anyone help me with an Excel Question

Topic closed. 4 replies. Last post 10 years ago by hypersoniq.

Page 1 of 1
PrintE-mailLink
Pick3Place's avatar - DiscoBallGlowing
Fort Lauderdale FL
United States
Member #50178
February 28, 2007
405 Posts
Offline
Posted: May 7, 2007, 10:32 am - IP Logged

The output of my P-3 software is 20, three digit numbers separated by a space between each number.  I take this output and paste it into a single cell on excel.  Is there then a way to get excel to separate each three digit numbers with a cama?  If anyone can help we can discuss on a private message.

Thanks in advance

P3P 

Jay at

Pick 3 Place

"May the numbers be with you"

All posts and predictions are for

entertainment purposes only.

    Avatar

    United States
    Member #41846
    June 23, 2006
    458 Posts
    Offline
    Posted: May 7, 2007, 7:39 pm - IP Logged

    P3P

    Paste your numbers into a word processor document,  wordpad word etc.

    save as text file

    now open this file using excel use the delimited option and choose space as delimiter.

    if I understood your data format this should put each 3 number group in a seperate line.

    you had indicated you wanted them seperated by a comma. If that was your objective use the word processor document and use the edit function, find and replace. look for space and replace with comma.  save document again as text file 

     

    hope this is what you were looking for

     

    P8 

      Todd's avatar - Cylon 2.gif
      Chief Bottle Washer
      New Jersey
      United States
      Member #1
      May 31, 2000
      23259 Posts
      Offline
      Posted: May 7, 2007, 7:48 pm - IP Logged

      The output of my P-3 software is 20, three digit numbers separated by a space between each number.  I take this output and paste it into a single cell on excel.  Is there then a way to get excel to separate each three digit numbers with a cama?  If anyone can help we can discuss on a private message.

      Thanks in advance

      P3P 

      It sounds like you have:

      123 456 789

      ...and you want to replace it with:

      123,456,789

      ...right?

      If so, don't do the replacement in Excel.  Just paste it into Notepad, then press Ctrl+H (Replace) type a space for the "Find" and a comma (,) for the replace.  Then click Replace All.

       

      A tip:  for the quickest, most accurate responses, it is always best to include an example as I have above.  It helps people understand exactly what you're looking for.

       

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

       

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

        Raven62's avatar - binary
        New Jersey
        United States
        Member #17843
        June 28, 2005
        49613 Posts
        Online
        Posted: May 7, 2007, 8:11 pm - IP Logged

        For an example, see the following thread:

        http://www.lotterypost.com/thread/155708/826141

        A mind once stretched by a new idea never returns to its original dimensions!

          hypersoniq's avatar - 8ball
          Pennsylvania
          United States
          Member #1340
          April 6, 2003
          2450 Posts
          Offline
          Posted: May 8, 2007, 9:43 pm - IP Logged

          if you are pasting straight to excel, then under the "data" menu item, use the "Text to Columns" option, this brings up the same delimiter options as importing a text file without the extra step.

          Playing more than one ticket per game is betting against yourself.