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

[µo°Ý] »²§UÄæ·j´M

[µo°Ý] »²§UÄæ·j´M

¥»©«³Ì«á¥Ñ wayne0303 ©ó 2021-8-19 14:13 ½s¿è

½Ð°Ý¤@¤U¡A¦pªþ¥óÀɪº§Î¦¡¡Aa8¤½¦¡¸Ó¦p¦ó¼g©O¡H

ÁÂÁ¡I

¬¡­¶Ã¯1.rar (10.08 KB)

A8:
="¦w¸Ë¼Ó¼h:"&1&-LEFT(RIGHT(A6,3))&"F"&LEFT(A5,2)

TOP

¦^´_ 2# ­ã´£³¡ªL


¤£¦n·N«ä­ã¤j¡I
¨º­Ó1¦³¥i¯à¬O1©Î¬OB1¡A¤½¦¡­n«ç»ò§ï©O¡H

ÁÂÁÂ

TOP

¦^´_ 3# wayne0303


="¦w¸Ë¼Ó¼h:"&MID(LEFT(A6,FIND("/",A6)-1),FIND("(",A6)+1,9)&"-"&TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(A6,")",),"/",REPT(" ",9)),9))

TOP

¦^´_ 4# ­ã´£³¡ªL


·PÁ­ã¤jªºÀ°¦£¡IÅý§Ú¥i¥H¾Ç²ß

ÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD