Forum Discussion
How should I extract Yes and No in excel
Hi everyone I have attach the excel sheet and wanted to find out how I could extract the 'x' inside the box to determine whether if the rows is "yes", "no" or "NA". I am completely lost with this...
A 365 solution:
=LET(split,TEXTSPLIT(A1,{"[","]"}),CHOOSE(XMATCH("x",split),,"Yes",,"No"))