No textNo textNo text

MS-Word help please!

Avatar
alNafa

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
Mone

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

I hope that helps.

Avatar
alNafa

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
lottaloot

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. 

Avatar
alNafa

lottaloot,
please post the Formula. thank you.

Al

MollyG's avatar - happy
MollyG

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
alNafa

thanks anyways.

MollyG's avatar - happy
MollyG

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
tntea

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..

Avatar
alNafa

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

MollyG's avatar - happy
MollyG

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
alNafa

excel.

MollyG's avatar - happy
MollyG

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

lottaloot's avatar - AvatarZ56
lottaloot

=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. 

SirMetro's avatar - center
SirMetro

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

TopEnd of thread (1 page)

Log In

Log InCancel

Forgot your username?

Forgot your password?