Sorry to keep 'pestering' you Harold, you seem to be the only person who has a grasp of my concern. I am using version 2.0.4 of OO on Windows XP. I guess the best way to explain my problem is to show you my spreadsheet. 579374448 2416253949 81524303132 1713273237
That example is just 4 rows of approximately 50. When I enter (try) any of your suggestions into the "find", the result is a hi-lite of only one number Say for example I need to find the numbers 8, 15, 16, 25, 32 and 49. I can search for 8, then search for 15, then 16, etc., one at a time which is time consuming, I would like "find" to hi-lite all six numbers all at once, like this: 579374448 2416253949 81524303132 1713273237 Oh and yes, the numbers are all whole numbers, they are not formulas or the results of formulas. Thanks again and I really do appreciate you assistance Larry, Brampton, Ontario, Canada Just to refresh; ---- Original Message ---- From: Larry To: Harold Fuchs Sent: Wednesday, December 20, 2006 2:53 PM Subject: [users] Re: Finding Several Numbers in Calc (was Re: [users] [moderated] YOU MUST GIVE A SUMMARY HERE) I wrote: Hi Harold, and thanks for the info. Unfortunately (what am I doing wrong here?) when I entered my search numbers: ^3$|^7$|^10$|^22$|^35$|^49$ according to your suggestion, the only result I get is it finds only the first number "3". Please assist, if you don't mind. Thanks Larry You replied with; Are the numbers displayed as integers on the screen? Trying to find "^7$" (no quotes) if the actual value shown is 7.3 won't work; if you want to find seven or seven point something the easiest way, although not the most concise, is to find ^7$|^7\..*$ The second part of that, after the bar, is caret 7 backslash dot dot asterisk dollar. Note the two dots - "\." means an actual dot" and ".*" means "any number, including zero, of any character" Are the numbers the results of formulae in the cells you are searching? If so, the technique doesn't work and I'm afraid I don't know how to do what you want. Anybody ??? Also, what version of OOo are you using and on what version of which Operating System? It is conceivable that Regular Expressions are broken in some versions. Harold Fuchs London, England
