Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Find two or more words in Excel?

04 Jan 2012   #1
lostsoul62

Windows 7 x64 RC1, Vista Ultimate, XP Pro
 
 
Find two or more words in Excel?

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 System SpecsSystem Spec
.

09 Jan 2012   #2
Neutron16

Windows 8.1 ; Windows 7 x86 (Dec2008-Jan2013)
 
 

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 System SpecsSystem Spec
Reply

 Find two or more words in Excel?




Thread Tools





Similar help and support threads
Thread Forum
Excel 2010, find & replace
Hi guys, In my Excel 2010 workbook there is a cell with the value of "90" in type of number/general. When I go to find and replace dialog box and try to find the number "90" by typing it in Find what rectangle, then I want the program looks for it in formulas (look in: Formulas). But it shows...
Microsoft Office
Microsoft Office 2007 Excel Find and Replace Command
I know I can do this as I have done it in the past a long time ago. Using the Find and Replace option add and extension to my sku numbers, such as: SKU # 8686708052 I have a column of these sku's and want to add the extension .jpg to all of them at one time! 8686708052.jpg
Microsoft Office
best soft to find pass for Excel 2010 files ??
best soft to find pass for Excel 2010 files ?? my Uncle create very important programs on Excel 2010 which tooks over 1-2 months to create but now they forgot its password I want to break its pass to help them
Microsoft Office
Need software to find duplicates in excel worksheets
Dear All, Can you plz suggest me a software that can find duplicate texts present in an excel file? I know there is an option called "Remove Duplicates" under Data section in excel, but it can only find duplicates present in the current worksheet. What i am looking for will allow me to...
Software
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 00:34.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App