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

²Î¤@¸ê®Æ®æ¦¡

²Î¤@¸ê®Æ®æ¦¡

¥­¦w
½Ð°Ý¥H¤U¥i¥H°µ¨ì¶Ü ?
¥x¥_¥««H¸q°Ï«H¸q¸ô3¬q15¸¹3F  
³z¹L¨ç¦¡§ï¬°
¥x¥_¥««H¸q°Ï«H¸q¸ô¤T¬q15¸¹3¼Ó
¦pªþ¥ó ­×¥¿¦r¦ê.rar (7.27 KB)
µL¤îºÉªº§V¤O¤W¶i

D2:D5=SUBSTITUTE(SUBSTITUTE(IFERROR(LEFT(A2,FIND("¬q",A2)-2)&TEXT(RIGHT(LEFT(A2,FIND("¬q",A2)-1)),"[DBNUM1]")&MID(A2,FIND("¬q",A2),99),A2),"f","F"),"F","¼Ó")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

ÁÂÁÂHcm19522
³o¬O¤@­Ó§xÂZ³\¤[ªº°ÝÃD
¤µ¤ÑÀò±o¸Ñ¨M
·P¿E¤£ºÉ
µL¤îºÉªº§V¤O¤W¶i

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD