Find two or more words in Excel?

lostsoul62

Banned
Local time
12:10 AM
Messages
380
Location
AZ
I have Office 10 and I go to "find" in my excel spreadsheet and I would like to find "shot", "hospital"". "doctor" without doing 3 searches. So can I imput those 3 words and do a search and it will show me each word as they come up?
 

My Computer My Computer

At a glance

Windows 7 x64 RC1, Vista Ultimate, XP ProAMD 9554 gigs - 13335750
OS
Windows 7 x64 RC1, Vista Ultimate, XP Pro
CPU
AMD 955
Memory
4 gigs - 1333
Graphics Card(s)
5750
Monitor(s) Displays
i-inc 28"
Screen Resolution
1920x1200
Hard Drives
2 SATA2 750 GB - 1 SATA2 1TB - 1 SATA3 1TB - 1 USB3 2TB - 1 USB3 500 GB, SSD 60 GB
Internet Speed
7 Megs
As far as I know there is no way to do that without creating a macro. But even macro will return you cell numbers for those words in specially assigned "answer" cells.
 

My Computer My Computer

At a glance

Windows 8.1 ; Windows 7 x86 (Dec2008-Jan2013)
Computer type
PC/Desktop
OS
Windows 8.1 ; Windows 7 x86 (Dec2008-Jan2013)
Other Info
"The scale icon at the top right of a post or tutorial is how you can give rep to the member."
Back
Top