searching for text in multiple spreadsheets 1

[ghost123uk]

OS = W2K-pro
Office = 2000 full

Situation =

Say I have a folder with 100 smallish spreadsheets in it.
I want to search them all to find a piece of text, (a serial number).

Can it be done ?



JB - N.W. - UK....
If at first you don't succeed, keep at it until you can't even think straight !

 

[SkipVought]

Hi,

Why not use the OFFICE Search feature to search for your value in that folder?

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[ghost123uk]

Do you mean the ctrl-F - shurely that only seaches the doc / xls that is already open - or am I being thick !

JB - N.W. - UK....
If at first you don't succeed, keep at it until you can't even think straight !

 

[SkipVought]

OFFICE Search,

not

Excel search

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[ghost123uk]

Thanks Skip

Took me a few minutes to figure out what you meant - but great !

For those other dense (like me) folks, I found it by going to "open office document" on the start bar, selecting the folder I wish to search, selecting "tools" at the top of r/h of the window, click "find", then fill in the "define more criteria" boxes, with "property" set to "contents" etc.

Very handy - all these years both myself and our other staff did not know about that one !


JB - N.W. - UK....
If at first you don't succeed, keep at it until you can't even think straight !