Compare Text using textbefore

[kiwikiki718]

Hello is there a way to compare the text of one colum to the results of the textbefore formula?

Ex I want to compare column A1 to the vaule of the Textbefore statement for B1. I want the vaule to show Yes if True and No if false.

Here is what I have but does not reflect the correct value.

If(A1=TEXTBEFORE(B1,”_”),”Yes”,”No”)

 

[kiwikiki718]

Hello is there a way to compare the text of one colum to the results of the textbefore formula?

Ex I want to compare column A1 to the vaule of the Textbefore statement for B1. I want the vaule to show Yes if True and No if false.

Here is what I have but does not reflect the correct value.

If(A1=TEXTBEFORE(B1,”_”),”Yes”,”No”)

 

[kiwikiki718]

I figured it out. with troubleshooting I found I had extra spaces in one of the cells.