If you wish Excel to keep the cell formatted exactly as entered, ... I resolved the issue by using =IF(MID(B31,6,1)="E","Y","N") to identify where the ...
確定! 回上一頁