Search for a Cell With Specific Text in Microsoft Excel

In this tutorial, we will go over how to search for a cell containing specific text in Microsoft Excel. First, we will show you how to use the built in find box. Next, we will show you how to use the SEARCH Function as well as the ISNUMBER function to display a True or False for searching for the desired text. Finally, we will show you how to use conditional formatting to highlight the cells with the value you wish to find. This is a great video for anyone wanting to learn how to search for a cell with specific text in Microsoft Excel!

Check out our Blog entry for Search for a Cell With Specific Text in Microsoft Excel here:

Search for a Cell With Specific Text in Microsoft Excel Time Stamps⌚

00:00 - Introduction to Search for a Cell With Specific Text in Microsoft Excel
00:41 - Search for Specific Text in Microsoft Excel Method #1-Using the Find Box
01:19 - Search for Specific Text in Microsoft Excel Method #2-Using the SEARCH Function
03:12 - Search for Specific Text in Microsoft Excel Method #3-Conditional Formatting
04:07 - Conclusion for Search for a Cell With Specific Text in Microsoft Excel
------------

🔥 OUR BEST EXCEL RESOURCES 🔥

👨‍🏫 Get 30+ Excel & Office Courses & support for 60% OFF! 💵 (All Excel levels covered)
Learn Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams, Project, PowerApps, PowerAutomate, Visio, Forms & MORE!

📚 Download Our Free 101 Excel Tips & Tricks E-Book:

💻 Access 1,000+ Free Excel & Office tutorials over at our award-winning blog:

📚Get All Our 101 Excel E-Book series on Formulas, Macros & Pivot Tables:

📚101 Most Popular Excel Formulas Paperback on Amazon:

📚101 Ways To Master Excel Pivot Tables Paperback on Amazon:

📚101 Ready To Use Excel Macros Paperback on Amazon:

📚101 Best Excel Tips & Tricks Paperback on Amazon:

👷 Excel Consulting Services:

💻 Looking for more Microsoft Excel & Office tutorials? Check out our playlist below:
------------

Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!

If you enjoyed the video, please give a thumbs up, comment, share.

Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)

Cheers,

JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP

❤️ Let’s connect on social ❤️

#MyExcelOnline #search #find #MsExcel

[MartinSeman-mf]

Could you please let me know if it is also possible to put this searching word "good" in cell D. So instead of true/false or number, I want to find this word "good" in text in column B and paste it to cell D

[lee.spatcher]

Could you please tell me why, when I press Control F I'm not getting the find all button come up? I need to do a find all search so they can all be highlighted at the same time followed by deleting them all in one go. Any ideas?

[BestOfYet]

What if you have more than one text you are looking for in a cell? Using your exmaple, what If I want to see any cells that has the words "good" "bad" "ugly"?