MS-Word help please!

Reply #14

SirMetro — Fri, 25 Nov 2005 22:54:36 GMT

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. S... [ More ]

Reply #13

lottaloot — Fri, 25 Nov 2005 20:22:38 GMT

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

Reply #12

MollyG — Fri, 25 Nov 2005 18:32:49 GMT

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

Reply #11

alNafa — Fri, 25 Nov 2005 18:28:36 GMT

excel.

Reply #10

MollyG — Fri, 25 Nov 2005 18:22:54 GMT

Depends on what spreadsheet you are using....Excel, Works, Lotus, etc.The formulas are usually different on each spreadsheet.

Reply #9

alNafa — Fri, 25 Nov 2005 17:49:06 GMT

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

Reply #8

tntea — Fri, 25 Nov 2005 16:01:28 GMT

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

Reply #7

MollyG — Fri, 25 Nov 2005 15:50:03 GMT

alNafa, I think the formula would be for a spreadsheet...not a document.It is the same formula needed in my above post.

Reply #6

alNafa — Fri, 25 Nov 2005 15:43:33 GMT

thanks anyways.

Reply #5

MollyG — Fri, 25 Nov 2005 15:29:08 GMT

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

Reply #4

alNafa — Fri, 25 Nov 2005 14:54:25 GMT

lottaloot,please post the Formula. thank you.Al

Reply #3

lottaloot — Wed, 23 Nov 2005 22:29:39 GMT

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.

Reply #2

alNafa — Wed, 23 Nov 2005 18:53:05 GMT

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

Reply #1

Mone — Wed, 23 Nov 2005 18:40:33 GMT

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

MS-Word help please!

alNafa — Wed, 23 Nov 2005 18:25:59 GMT

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