Excel IF Function IF Cell Contains specific text - Partial Match and Exact Match - REGEXTEST

Опубликовано: 19 Октябрь 2024
на канале: Excel Bootcamp

1,233

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: https://excelkid.com/regex-in-excel/

🚀 Get DataFX Free Function library: https://excelkid.com/add-ins/

🎓 LEARN MORE in my Excel tutorials: https://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: https://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