Welcome Guest
Log In | Register )
You last visited January 21, 2017, 4:15 am
All times shown are
Eastern Time (GMT-5:00)

Can someone help with an Excel question

Topic closed. 3 replies. Last post 10 years ago by winsumloosesum.

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, 11:47 am - IP Logged

My P-3 software outputs 20 three didget numbers separated by a space between each pick.

I paste this output into a single cell on excel.  So within this cell there are 20 3 digit numbers.

 Example:

167 169 160 179 170 679 853 190 352 670

453 690 852 458 790 832 452 843 432 842 

Is there a way then to get excel to comma diliniate these 20 three digit numbers.

Thanks in advance

P3P

Jay at

Pick 3 Place

"May the numbers be with you"

All posts and predictions are for

entertainment purposes only.

    CARBOB's avatar - FL LOTTERY_LOGO.png
    ORLANDO, FLORIDA
    United States
    Member #4924
    June 3, 2004
    5972 Posts
    Online
    Posted: May 7, 2007, 12:22 pm - IP Logged

    My P-3 software outputs 20 three didget numbers separated by a space between each pick.

    I paste this output into a single cell on excel.  So within this cell there are 20 3 digit numbers.

     Example:

    167 169 160 179 170 679 853 190 352 670

    453 690 852 458 790 832 452 843 432 842 

    Is there a way then to get excel to comma diliniate these 20 three digit numbers.

    Thanks in advance

    P3P

    Put cursor In the first cell where your data is located, make sure the next 9 columns to the right are empty!! Click Data- Text to Columns, follow instructions!!

    Hope this helps.

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5396 Posts
      Offline
      Posted: May 13, 2007, 3:02 pm - IP Logged

      My P-3 software outputs 20 three didget numbers separated by a space between each pick.

      I paste this output into a single cell on excel.  So within this cell there are 20 3 digit numbers.

       Example:

      167 169 160 179 170 679 853 190 352 670

      453 690 852 458 790 832 452 843 432 842 

      Is there a way then to get excel to comma diliniate these 20 three digit numbers.

      Thanks in advance

      P3P

      If all 20 numbers are in Cell A1

      If you want to put all 20 combos in cell B1 and replace the spaces with a comas here is the formula you place in cell B1

      =LEFT(SUBSTITUTE(A1," ",","),LEN(A1)-1)

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5396 Posts
        Offline
        Posted: May 13, 2007, 3:52 pm - IP Logged

        My P-3 software outputs 20 three didget numbers separated by a space between each pick.

        I paste this output into a single cell on excel.  So within this cell there are 20 3 digit numbers.

         Example:

        167 169 160 179 170 679 853 190 352 670

        453 690 852 458 790 832 452 843 432 842 

        Is there a way then to get excel to comma diliniate these 20 three digit numbers.

        Thanks in advance

        P3P

        This is a link to an excel file with User Defined Function (UDF)

        http://rapidshare.com/users/K89UOL