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

An Excel problem

Topic closed. 8 replies. Last post 9 years ago by Raven62.

Page 1 of 1
PrintE-mailLink
Fibonacci's avatar - Lottery-050.jpg
New York, NY
United States
Member #39471
May 16, 2006
2696 Posts
Offline
Posted: December 5, 2007, 1:50 pm - IP Logged

Don't know if Excel is the way to go.

 If I have a list of numbers looking like below (much larger reality), how could I get them quickly into a single column either in excel? If it can be done in notepad that would be okay.

 0907 6963 9572 1929 3969 1617 0224 7508 6761 0249 9321 9914 4442 0720 5131 6383 5000 4552 8444 5298 1772 4574 3897 6088 2386 1733 5946 6172 2587 8987 7400 2640 7139 3928 7070 5074 6071 0359 9133 4362 7734 2175 3405 2868 2263 6515 3350 2294 7708 7633 4483 8634 6788 0115 6942 1774 0026 9112 7697 1540 3748 5339 2374 7923 5150 4094 3633 7671 1910 8933 4382 2335 0016 8887 3212 0233 2493 5747 6793 9593 2432 8213 5133 4031 7885 3677 6606 9846 8468 0133 0337 1812 3752 5080 0621 6054 4355 3726 9315 7372 7497 5838 3436 1541 1312 6417 8448 1525 1400 3797 5974 2054 2999 5175 8574 8291 2182 0388 2268 3500 9271 4974 7989 9886 0269 2910 3485 4967 1441 8716 7111 7465 4427 2150 6500 8977 4529 4299 5069 3632 8395 0633 6057 5115 4640 6510 2677 9799 3870 1216 2472 3105 3733 0592 7480 8497 6838 5733 4888 2770 1890 3403 4639 2017 2345 5885 0584 7051 5716 7032 9155 2607 4787 4889 5379 1103 2548 8416 3516 3407 3461 9398 7541 5231 3102 4878 9555 2269 5592 5054

$$$

    JKING's avatar - Kaleidoscope 3.gif

    United States
    Member #5599
    July 13, 2004
    1184 Posts
    Offline
    Posted: December 5, 2007, 1:55 pm - IP Logged

    Try this for a resource:

    http://www.mrexcel.com/board2/viewforum.php?f=18

    You are a slave to the choices you have made.  jk

    Even a blind squirrel will occasioanlly find an acorn.

      Raven62's avatar - binary
      New Jersey
      United States
      Member #17843
      June 28, 2005
      49693 Posts
      Offline
      Posted: December 5, 2007, 3:03 pm - IP Logged

      0907
      6963
      9572
      1929
      3969
      1617
      0224
      7508
      6761
      0249
      9321
      9914
      4442
      0720
      5131
      6383
      5000
      4552
      8444
      5298

      Text Wiz

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

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5387 Posts
        Offline
        Posted: December 5, 2007, 4:29 pm - IP Logged

        Don't know if Excel is the way to go.

         If I have a list of numbers looking like below (much larger reality), how could I get them quickly into a single column either in excel? If it can be done in notepad that would be okay.

         0907 6963 9572 1929 3969 1617 0224 7508 6761 0249 9321 9914 4442 0720 5131 6383 5000 4552 8444 5298 1772 4574 3897 6088 2386 1733 5946 6172 2587 8987 7400 2640 7139 3928 7070 5074 6071 0359 9133 4362 7734 2175 3405 2868 2263 6515 3350 2294 7708 7633 4483 8634 6788 0115 6942 1774 0026 9112 7697 1540 3748 5339 2374 7923 5150 4094 3633 7671 1910 8933 4382 2335 0016 8887 3212 0233 2493 5747 6793 9593 2432 8213 5133 4031 7885 3677 6606 9846 8468 0133 0337 1812 3752 5080 0621 6054 4355 3726 9315 7372 7497 5838 3436 1541 1312 6417 8448 1525 1400 3797 5974 2054 2999 5175 8574 8291 2182 0388 2268 3500 9271 4974 7989 9886 0269 2910 3485 4967 1441 8716 7111 7465 4427 2150 6500 8977 4529 4299 5069 3632 8395 0633 6057 5115 4640 6510 2677 9799 3870 1216 2472 3105 3733 0592 7480 8497 6838 5733 4888 2770 1890 3403 4639 2017 2345 5885 0584 7051 5716 7032 9155 2607 4787 4889 5379 1103 2548 8416 3516 3407 3461 9398 7541 5231 3102 4878 9555 2269 5592 5054

        Fib,

        If you have this saved in Notepad in multiple columns. (text file)

        Here is a link to a pdf that will help.

        http://www.rdpsd.ab.ca/ourpeople/its/training/SessionHandouts/Importing%20and%20Organizing%20Data.pdf 

          Fibonacci's avatar - Lottery-050.jpg
          New York, NY
          United States
          Member #39471
          May 16, 2006
          2696 Posts
          Offline
          Posted: December 5, 2007, 6:43 pm - IP Logged

          Steve Thanks. That pdf proved helpful.

          Raven I could not d/l textwiz --it says the file is discontinued but i am searching for it on sourceforge. JRking thanks for the forum link.

          I have it figured out now and so much more from your great help everyone.

          Ta 

          $$$

            LottoChica23's avatar - Aquarius
            Fughedaboutit (NY)
            United States
            Member #8160
            October 26, 2004
            6777 Posts
            Offline
            Posted: December 5, 2007, 7:11 pm - IP Logged

            Don't know if Excel is the way to go.

             If I have a list of numbers looking like below (much larger reality), how could I get them quickly into a single column either in excel? If it can be done in notepad that would be okay.

             0907 6963 9572 1929 3969 1617 0224 7508 6761 0249 9321 9914 4442 0720 5131 6383 5000 4552 8444 5298 1772 4574 3897 6088 2386 1733 5946 6172 2587 8987 7400 2640 7139 3928 7070 5074 6071 0359 9133 4362 7734 2175 3405 2868 2263 6515 3350 2294 7708 7633 4483 8634 6788 0115 6942 1774 0026 9112 7697 1540 3748 5339 2374 7923 5150 4094 3633 7671 1910 8933 4382 2335 0016 8887 3212 0233 2493 5747 6793 9593 2432 8213 5133 4031 7885 3677 6606 9846 8468 0133 0337 1812 3752 5080 0621 6054 4355 3726 9315 7372 7497 5838 3436 1541 1312 6417 8448 1525 1400 3797 5974 2054 2999 5175 8574 8291 2182 0388 2268 3500 9271 4974 7989 9886 0269 2910 3485 4967 1441 8716 7111 7465 4427 2150 6500 8977 4529 4299 5069 3632 8395 0633 6057 5115 4640 6510 2677 9799 3870 1216 2472 3105 3733 0592 7480 8497 6838 5733 4888 2770 1890 3403 4639 2017 2345 5885 0584 7051 5716 7032 9155 2607 4787 4889 5379 1103 2548 8416 3516 3407 3461 9398 7541 5231 3102 4878 9555 2269 5592 5054

            If you ever come across this problem again with the numbers in an excel file, just:

            1.highlight and copy a complete row

            2.move to a blank cell away from the rest of the numbers

            3.right click, select Paste Special, click the transpose box

            4.click OK.

             

            Your numbers that you copied from the row will then be in a single column.

            HTH for the future

            Matrix Chart Instructions--> http://www.lotterypost.com/thread/191818 

            check out mysticwomyn Announcers --> http://www.lotterypost.com/thread/140695/673306

            You can judge the integrity of a man by the way he treats those that can do nothing for him...Thumbs Up

              Fibonacci's avatar - Lottery-050.jpg
              New York, NY
              United States
              Member #39471
              May 16, 2006
              2696 Posts
              Offline
              Posted: December 5, 2007, 7:15 pm - IP Logged

              If you ever come across this problem again with the numbers in an excel file, just:

              1.highlight and copy a complete row

              2.move to a blank cell away from the rest of the numbers

              3.right click, select Paste Special, click the transpose box

              4.click OK.

               

              Your numbers that you copied from the row will then be in a single column.

              HTH for the future

              Thanks. I knew about the transpose feature but it doesn't work with this type of problem where all the numbers are already in horizontal cell.

              $$$

                LottoChica23's avatar - Aquarius
                Fughedaboutit (NY)
                United States
                Member #8160
                October 26, 2004
                6777 Posts
                Offline
                Posted: December 5, 2007, 7:27 pm - IP Logged

                Thanks. I knew about the transpose feature but it doesn't work with this type of problem where all the numbers are already in horizontal cell.

                Since the 4 digit numbers appear to be separated by a space in your example, you could save the file as a text file and then open the text file in excel. When you open the text file in excel,  open it as Delimited,select Next then select "space" as the the delimiter. This will put each 4 digit number into its own cell and then you can copy and Paste Special using the Transpose feature. 

                Matrix Chart Instructions--> http://www.lotterypost.com/thread/191818 

                check out mysticwomyn Announcers --> http://www.lotterypost.com/thread/140695/673306

                You can judge the integrity of a man by the way he treats those that can do nothing for him...Thumbs Up

                  Raven62's avatar - binary
                  New Jersey
                  United States
                  Member #17843
                  June 28, 2005
                  49693 Posts
                  Offline
                  Posted: December 6, 2007, 12:47 am - IP Logged

                  Steve Thanks. That pdf proved helpful.

                  Raven I could not d/l textwiz --it says the file is discontinued but i am searching for it on sourceforge. JRking thanks for the forum link.

                  I have it figured out now and so much more from your great help everyone.

                  Ta 

                  That's mighty strange: FYI: I downloaded the file from the site, then I compared it to the copy I have to verify that the download was good: All before posting the link.

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