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
Formatting words in bold give words in bold and italics
Hi, I don't know if anyone here had the same problem as me, but on a particular word document, whenever I choose a sentence to make it bold, it becomes automatically bold+italics. However, the italics sign is not clicked and therefore I cannot remove the Italics. Any help on how I can solve...
Microsoft Office
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


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 06:19.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App