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

(¤w¸Ñ¨M)VBA¸Ì­±ªº¤½¦¡¥i¥H¤À¬q¼g¶Ü

(¤w¸Ñ¨M)VBA¸Ì­±ªº¤½¦¡¥i¥H¤À¬q¼g¶Ü

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:09 ½s¿è

Range("J5") = _
        "=IF(LEFT(RC[-9],1)=""1"",IF(OR(RC[-8]=""¥Ò¾J"",RC[-8]=""¥ÒîÇ"",RC[-8]=""×ô""),""¤Æ¾Ç¼Ñ"",IF(OR(LEFT(RC[-8],2)=""EH"",LEFT(RC[-8],2)=""LK"",LEFT(RC[-8],2)=""NH"",LEFT(RC[-8],2)=""PH"",LEFT(RC[-8],2)=""SH"",LEFT(RC[-8],2)=""VH""),""­ì¯È"",IF(LEFT(RC[-8],3)=""¤ì§÷"",""¤ì§÷"",""¨ä¥L""))),IF(LEFT(RC[-9],1)=""3"",IF(LEFT(RC[-8],1)=""R"",""ª÷ÄÝ"",""¥¬®Æ""),IF(LEFT(RC[-9],1)=""4"",IF(LEFT(RC[-8],6)=""AU-910"",""9103"",RIGHT(LEFT(RC[-8],7),4)),IF(LEFT(RC[-9],1)=""5"",IF(OR(LEFT(RC[-8],2)=""IP"",LEFT(RC[-8],2)=""NH"",LEFT(RC[-8],2)=""SH""),""¤ô´¹"",IF(LEFT(RC[-8],3)=""¤ì§÷"",""¤ì§÷"",IF(LEFT(RC[-8],3)=""Æp¥Û"",""Æp¥Û"",""¨ä¥L""))),IF(LEFT(RC[-9],1)=""6"",""¥¬®Æ"",""¨ä¥L"")))))"

¤W­±³o¬O¤@­Ó¤½¦¡¡A­ì¥»§Ú·Q­nÅý¥L¥i¥H¤À¦æ¨Ï¥Î _ ªº¤è¦¡³B²z¡Aµ²ªG¨S¿ìªk°õ¦æ¡A¥u¯à·Ó­ì¨Óªºªø«×
½Ð°Ý¤½¦¡¥i¥H¤À¦æ¶Ü?
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

¥»©«³Ì«á¥Ñ victorl ©ó 2010-7-2 23:52 ½s¿è

¦^´_ 1# freeffly


    Range("J5") = _
"=IF(LEFT(RC[-9],1)=""1"",IF(OR(RC[-8]=""¥Ò¾J"",RC[-8]=""¥ÒîÇ"",RC[-8]=""×ô""),""¤Æ¾Ç¼Ñ""," & _
"IF(OR(LEFT(RC[-8],2)=""EH"",LEFT(RC[-8],2)=""LK"",LEFT(RC[-8],2)=""NH"",LEFT(RC[-8],2)=""PH"",LEFT(RC[-8],2)=""SH"",LEFT(RC[-8],2)=""VH""),""­ì¯È""," & _
"IF(LEFT(RC[-8],3)=""¤ì§÷"",""¤ì§÷"",""¨ä¥L""))),IF(LEFT(RC[-9],1)=""3"",IF(LEFT(RC[-8],1)=""R"",""ª÷ÄÝ"",""¥¬®Æ"")," & _
"IF(LEFT(RC[-9],1)=""4"",IF(LEFT(RC[-8],6)=""AU-910"",""9103"",RIGHT(LEFT(RC[-8],7),4)),IF(LEFT(RC[-9],1)=""5""," & _
"IF(OR(LEFT(RC[-8],2)=""IP"",LEFT(RC[-8],2)=""NH"",LEFT(RC[-8],2)=""SH""),""¤ô´¹"",IF(LEFT(RC[-8],3)=""¤ì§÷"",""¤ì§÷""," & _
"IF(LEFT(RC[-8],3)=""Æp¥Û"",""Æp¥Û"",""¨ä¥L""))),IF(LEFT(RC[-9],1)=""6"",""¥¬®Æ"",""¨ä¥L"")))))"
¦P¤å¦r¦ê¤è¦¡³B²z

TOP

¶â
³oºØ¤è¦¡¤£·|¥X²{¿ù»~
ÁÂÁ³á!
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

        ÀR«ä¦Û¦b : °ß¨ä´L­«¦Û¤vªº¤H¡A¤~§ó«i©óÁY¤p¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD