ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¤å¦rªº¦~¤ë¤é¡A¸É¦¨¨â¦ì¼Æ

¦^´_ 1# iceandy6150

¤]¥i¥H¥Î FIND MID¤§Ãþªº¨ç¼Æ

=TEXT(SUMPRODUCT(IFERROR(MID(A1,FIND({"¦~";"¤ë";"¤é"},A1)-{2,1},1)*10^{5,4;3,2;1,0},0)),"00¦~00¤ë00¤é")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD