2000+ using XLSheet AI still type gender manually 😭 Stop doing this If title is in D2 Use =IF(LEFT(D2,3)="Mr.","Male", IF(LEFT(D2,4)="Mrs.","Female", IF(LEFT(D2,3)="Ms.","Female",""))) Drag down Done Automate the boring stuff #excel #excelformulas #xlsheetai #productivity #exceltips #excel