Hi there. I am wanting to correct a formula. I would like E2 to say TBA if B2 CONTAINS the word TBA. I thought the star around TBA would do this, but clearly it doesn't. What am I doing wrong?
[Re-Titled by Moderator]
iMac 24″, macOS 15.3
HayleyHatzi wrote:
I thought the star around TBA would do this, but clearly it doesn't.
You were close! The * wildcard will work with COUNTIF:
=IF(COUNTIF(B2,"*TBA*")>0,"TBA","")
You can also use COUNTMATCHES without a wildcard, like this:
=IF(COUNTMATCHES(B2,"TBA")>0,"TBA","")
Replace , with ; in the formulas if your region uses , as a decimal separator.
SG
SG
HayleyHatzi wrote:
I thought the star around TBA would do this, but clearly it doesn't.
You were close! The * wildcard will work with COUNTIF:
=IF(COUNTIF(B2,"*TBA*")>0,"TBA","")
You can also use COUNTMATCHES without a wildcard, like this:
=IF(COUNTMATCHES(B2,"TBA")>0,"TBA","")
Replace , with ; in the formulas if your region uses , as a decimal separator.
SG
SG
Not knowing what you need maybe my proposal is not the right one.
If you just want it to report the TBA text of B2 if it contains it, be it at the beginning, center or end of the string, you could try REGEXEXTRACT. His formula extracts the searched text from you. Inside IFERROR, if there is no TBA it returns empty
=IFERROR(REGEXEXTRACT(B2;”\bTBA\b";1;);"")
If it doesn't work replace ; with ,
รูผภาพต่างๆๆ
I'm really sorry I don't understand this language.
Perfect! I really don't understand the >0, what does that mean? Is this replacing iferror?
> 0 means there were more than 0 matches, meaning TBA occurred at least once in the text.
SG
Thank you so much for your explanation....you have solved my problem! I appreciate your assistance.
How to make E2 display 'TBA' if B2 contains the word 'TBA' in a formula on Numbers?
