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

MS-Word help please!

Topic closed. 14 replies. Last post 11 years ago by SirMetro.

Page 1 of 1
PrintE-mailLink
Avatar
new york
United States
Member #21780
September 14, 2005
118 Posts
Offline
Posted: November 23, 2005, 1:25 pm - IP Logged

im trying to have the MS-Word Find function find a number in in a document to see if it's repeated by searching for it in all of its possible ways. for ex: 123 , 132 , 213 , 231 , 312 , 321. i can't figure out an easier ways to do this other than actually typing every number in the Find box..it's a really pain..

Thank you,

 

Al 

    Mone's avatar - appleboy
    Nassau
    Bahamas
    Member #1514
    May 16, 2003
    606 Posts
    Offline
    Posted: November 23, 2005, 1:40 pm - IP Logged

    I believe u could go into edit then scroll down to find then put in yr info.

    I hope that helps.

    MONE

      Avatar
      new york
      United States
      Member #21780
      September 14, 2005
      118 Posts
      Offline
      Posted: November 23, 2005, 1:53 pm - IP Logged

      thanks for replying.

      what i'm looking for (exactly) is to be able to enter for example 123 ONLY in the Find box, and what the Function would do is find: 123 , 132 , 213 , 231 , 312 , 321 for me..If it is possible, it will help me eliminate the other 5 numbers (132 , 213 , 231 , 312 , 321) when i play that number boxed.. I don't think that is possible in MS-Word, but just thought someone might know an easier way...thanks.

       

      Al 

        lottaloot's avatar - AvatarZ56
        Redford/MI
        United States
        Member #3396
        January 18, 2004
        4867 Posts
        Offline
        Posted: November 23, 2005, 5:29 pm - IP Logged

        thanks for replying.

        what i'm looking for (exactly) is to be able to enter for example 123 ONLY in the Find box, and what the Function would do is find: 123 , 132 , 213 , 231 , 312 , 321 for me..If it is possible, it will help me eliminate the other 5 numbers (132 , 213 , 231 , 312 , 321) when i play that number boxed.. I don't think that is possible in MS-Word, but just thought someone might know an easier way...thanks.

         

        Al 

        Sorry.  You must go thru the process of manually typing out each combination. 

        Been there, done that. 

        Luckily, I placed my data into excel & sirmetro provided me with a formula that puts the combo into box format.  This way I am able to search like that. 

        L ttaL   T

          Avatar
          new york
          United States
          Member #21780
          September 14, 2005
          118 Posts
          Offline
          Posted: November 25, 2005, 9:54 am - IP Logged

          lottaloot,
          please post the Formula. thank you.

          Al

            MollyG's avatar - happy
            TEXAS (yeah!)Katy
            United States
            Member #9019
            November 25, 2004
            523 Posts
            Offline
            Posted: November 25, 2005, 10:29 am - IP Logged

            Are all your numbers (123) in the same column, or in 3 different columns?

            You will need 1 column that has the numbers in numerical order....123

            Not 132.  You can have the original set as listed....132, but will need the column next to it in series order....123.  Then the "find" can locate all of them.

            OOPs!!!  I was thinking of a spreadsheet.  Sorry.  As I re-read your message, I realized it was a document.Embarassed

              Avatar
              new york
              United States
              Member #21780
              September 14, 2005
              118 Posts
              Offline
              Posted: November 25, 2005, 10:43 am - IP Logged

              thanks anyways.

                MollyG's avatar - happy
                TEXAS (yeah!)Katy
                United States
                Member #9019
                November 25, 2004
                523 Posts
                Offline
                Posted: November 25, 2005, 10:50 am - IP Logged

                lottaloot,
                please post the Formula. thank you.

                Al

                alNafa, I think the formula would be for a spreadsheet...not a document.

                It is the same formula needed in my above post.

                  tntea's avatar - Lottery-059.jpg

                  United States
                  Member #5344
                  June 30, 2004
                  23641 Posts
                  Offline
                  Posted: November 25, 2005, 11:01 am - IP Logged

                  im trying to have the MS-Word Find function find a number in in a document to see if it's repeated by searching for it in all of its possible ways. for ex: 123 , 132 , 213 , 231 , 312 , 321. i can't figure out an easier ways to do this other than actually typing every number in the Find box..it's a really pain..

                  Thank you,

                   

                  Al 

                  upgrading membership will allow you to check a number for the entire history of any state..

                  it is a great feature to use. you type it in one time.. and presto.. get your results..

                       OLD/Vtrac   Lottery Bible         Double Warnings      Thumbs Up TN F34/F44

                    Avatar
                    new york
                    United States
                    Member #21780
                    September 14, 2005
                    118 Posts
                    Offline
                    Posted: November 25, 2005, 12:49 pm - IP Logged

                    MollyG, can i use that formula if i move my numbers to a spreadsheet?

                      MollyG's avatar - happy
                      TEXAS (yeah!)Katy
                      United States
                      Member #9019
                      November 25, 2004
                      523 Posts
                      Offline
                      Posted: November 25, 2005, 1:22 pm - IP Logged

                      MollyG, can i use that formula if i move my numbers to a spreadsheet?

                      Depends on what spreadsheet you are using....Excel, Works, Lotus, etc.

                      The formulas are usually different on each spreadsheet.

                        Avatar
                        new york
                        United States
                        Member #21780
                        September 14, 2005
                        118 Posts
                        Offline
                        Posted: November 25, 2005, 1:28 pm - IP Logged

                        excel.

                          MollyG's avatar - happy
                          TEXAS (yeah!)Katy
                          United States
                          Member #9019
                          November 25, 2004
                          523 Posts
                          Offline
                          Posted: November 25, 2005, 1:32 pm - IP Logged

                          If you can use Excel...YES, you will have no problem.  I will PM you.

                            lottaloot's avatar - AvatarZ56
                            Redford/MI
                            United States
                            Member #3396
                            January 18, 2004
                            4867 Posts
                            Offline
                            Posted: November 25, 2005, 3:22 pm - IP Logged

                            =CONCATENATE((MIN(LEFT($C2),MID($C2,2,1),RIGHT($C2))),(MEDIAN(LEFT($C2),MID($C2,2,1),RIGHT($C2))),(MAX(LEFT($C2),MID($C2,2,1),RIGHT($C2))))

                             

                            This excel formula will change your draw results into a box format that allows you to search in the manner that you spoke of earlier. 

                            L ttaL   T

                              SirMetro's avatar - center
                              East of Atlanta
                              United States
                              Member #6191
                              August 11, 2004
                              1389 Posts
                              Offline
                              Posted: November 25, 2005, 5:54 pm - IP Logged

                              Just a general thought.

                              When developing your spreadsheet, do NOT try to do everything inside one cell. When that happens, you end up with incredibly complex formulas that are nearly impossible to debug if they do not work.

                              Always think "Divide & Conquer".

                              Also, take the time to understand formulas. They can be your best friend and your worst nightmare. Learn how to make the computer an extension of your thought process. Also, consider the method you are intending to use. Give it a bit of thought. Sketch it out on paper.

                              And perhaps the most important, Test your ideas/results BEFORE you spend the $$$.

                              Another note, easiest way to transfer your numbers to a spreadsheet is to use the following steps:

                              1) Save the word file as a ASCII TXT file

                              2) Open this file with NOTEPAD

                              3) Make sure everything appears uniform (crucial when importing into Excel). I suggest that you use a SPACE between the Date Column and the Number Column.

                              4) Save the file with Notepad & Close it.

                              5) Open the file in Excel. To open the TXT file you have created and saved in Notepad, make sure the Drop Down box reads "ALL FILES" instead of just "EXCEL FILES".

                              6) Once you found the file and clicked OK to open it, you will get a message box indicating that it is NOT an excel file, Open any way?, click yes. The Next screen you see will be the data in TXT file. If you use the SPACE as a Delimiter, Excel will assist you in the import. It is IMPORTANT that you try to import the date in one column and the numbers in another column by itself. Otherwise, you will need other formulas to break the data out.

                              I hope this helps some.

                              Sir Metro