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

[µo°Ý] ¨ú¥N¥\¯à

[µo°Ý] ¨ú¥N¥\¯à

¥»©«³Ì«á¥Ñ cdkee ©ó 2016-8-3 11:41 ½s¿è

½Ð±Ð¤j¤j¡A±N©Ò¿ï¼Æ¦r¤§«e©Î¤§«á¥[¤W­^¤å¦r¡AÀ³¸Ó¦p¦ó?ÁÂÁÂ!
¨Ò¦p: 321ÂনD321©ÎD321D

¥»©«³Ì«á¥Ñ VBALearner ©ó 2016-8-3 13:11 ½s¿è

¦^´_ 1# cdkee

¥i¥H¥ÎVBA±Ð¶Ü«¢«¢«¢?
¤£»Ýµ{¦¡ªº¤èªk¦p¤U
°²³]A1Àx¦s®æªº­È¬OD
B1Àx¦s®æªº­È¬O321
¦bC1¿é¤J"=A1&B1"§Y·|¥X²{D321
©Î¬O"=A1&B1&A1"´N·|¥X²{D321D

TOP

¦^´_ 2# VBALearner

ÁÂÁ¤j¤j!

TOP

°²³]A1Àx¦s®æªº­È¬ONumber
=IF(ISNUMBER(A1),"D" & A1 & "D",A1)

TOP

¦^´_ 4# ikboy


    ÁÂÁ¤j¤j!

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD