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

excel help

Topic closed. 17 replies. Last post 12 years ago by winsumloosesum.

Page 2 of 2
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
Posted: April 13, 2005, 10:53 pm - IP Logged



GameDateResults
Cash 35/1/20048, 7, 7
Cash 35/2/20046, 5, 0
Cash 35/3/20047, 4, 2
Cash 35/4/20042, 4, 3
Cash 35/5/20049, 4, 4
Cash 35/6/20042, 7, 3
Cash 35/7/20049, 6, 4
Cash 35/8/20048, 4, 1
Cash 35/9/20044, 4, 5
Cash 35/10/20043, 5, 9

 

I am trying to import previous lottery results into an excel spreadsheet. 

The above is how it looks--Just wondering if there is any way that I can get rid of the , so that I can just cut and paste results into the specific area that I want.

If your 3 digit numbers are in one column you can select the entire column.

Go to you Menu bar and choose > Data > Text to Columns > Delimited > Select Coma (make sure all the other Delimiters are unchecked> Click Finish

Each number will be in their own individual column.

If you want to put all three digits in 1 cell use the following formula:

This is if Position 1 is in cell A1, Position 2 is in cell B1, and Position 3 is in cell C1.

This formula below would go in cell D1

=CONCATENATE(a1,b1,c1)

Hope this helps!!

Winsum

    time*treat's avatar - radar

    United States
    Member #13130
    March 30, 2005
    2171 Posts
    Offline
    Posted: April 15, 2005, 6:28 pm - IP Logged

    *color printouts*

    In the vb editor, onscreen, you can have keywords one color, and comments another color and so on. I'm wondering if any of you know how to get the printout of the 'code' in this multi-color format.

    In neo-conned Amerika, bank robs you.
    Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5387 Posts
      Offline
      Posted: April 15, 2005, 10:18 pm - IP Logged

      0= 15                                                              0

      1= 12                                             

      2= 8                                                         7              1

      3= 9

      4= 8                                                    6           3             4

      5= 8

      6= 11                                               5        2           8           9

      7= 13

      8= 5

      9= 4



      Shanemc1



      How would you wheel you Pyriamid??



      winsum