kiwikiki718
Board Regular
- Joined
- Apr 7, 2017
- Messages
- 80
- Office Version
- 365
- Platform
- Windows
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”)
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”)