In this video, I'll show you how to use the Excel IF function to test IF a cell contains specific text. The video contains 2 examples of using the REGEXTEST function to check that the cell contains a partial or exact match. You can combine the REGEXTEST function with the IF function to perform various tests.
🚀Regex Guide: excelkid.com/regex-in-excel/
🚀 Get DataFX Free Function library: excelkid.com/add-ins/
🎓 LEARN MORE in my Excel tutorials: excelkid.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
🎁 SHARE this video and spread the Excel love.
Chapters:
00:00 Intro
00:05 IF Cell Contains Specific Text - Partial Match
01:01 IF Cell Contains Specific Text - Exact Match
🎓 LEARN MORE in my Excel tutorials: excelkid.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
🎁 SHARE this video and spread the Excel love.
Or if you are in a hurry, please click the 👍
#exceltips #exceltutorial #excel