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

[µo°Ý] ©T©wÄæ¼e®M¦L...¤¤¤å+¨®µP­^¤å¦r¥À+¼Æ¦r

[µo°Ý] ©T©wÄæ¼e®M¦L...¤¤¤å+¨®µP­^¤å¦r¥À+¼Æ¦r

¦³¤@®M¦LÀɬO©T©wÄæ¼e®M¦L...¤¤¤å+¨®µP­^¤å¦r¥À+¼Æ¦r

§Æ±æ¯à±N 1 ©Î 2 ªº´ú¸Õ¤å¦r
¦Û°Ê§ì¨ú¦Ü B3:B7 Àx¦s®æ³B®M¦L
B3Àx¦s®æ¯à®e 8­Ó¤¤¤å¦r(¥¿±`¦r¤j¤p)
°ÝÃD¥X²{¦b B4 ¦]¦³¤¤¤å+¨®µP­^¤å¦r¥À+¼Æ¦r¦]¯À
³y¦¨¤½¦¡¤£¦n®³®º...
B3:B7 ¬O®M¦L½d³ò

1221.jpg
2023-12-21 02:30


1121221.rar (6.96 KB)

¦^´_ 1# cypd


    ¤£¨Ï¥Î¦r¼Æ¡A½Ð¨Ï¥Î¦ì¤¸³]©w§Y¥i¡C
¤¤¤å¦r¥H¤Î "¡A¡C¡B" µ¥³£¬O­p2¦ì¤¸¡A­^¤å¥H¤Î­^¤å²Å¸¹­p1¦ì¤¸¡C

¬G¨Ï¥Î¤½¦¡¦p¤U¡G
B3¡G=LEFTB(P4,16)               Àò¨ú«e16¦ì¤¸
B4¡G=MIDB($P$4,17,16)     Àò¨ú²Ä17¦ì¤¸¶}©l¦@16¦ì¤¸
B5¡G=MIDB($P$4,33,16)     Àò¨ú²Ä33¦ì¤¸¶}©l¦@16¦ì¤¸
B6¡G=MIDB($P$4,49,16)     Àò¨ú²Ä49¦ì¤¸¶}©l¦@16¦ì¤¸
B7¡G=MIDB($P$4,65,16)     Àò¨ú²Ä65¦ì¤¸¶}©l¦@16¦ì¤¸

TOP

¦^´_ 2# goner

«D±`·PÁ  goner  ¼ö¤ßªº¦^ÂÐ
«D±`©êºp...¦]°ÝÃD¤¤¦³Â¨®¨®µP¦]¯À
©Ò¥H¦³¦p¤Uª¬ªp
B4:B7 ¶¡¤§Àx¦s®æ¦]¨®µP¦]­^¤å¦r¥À¤Ö¤@½XÃö«Y
³y¦¨¥ª¥kªÅ¥Õ¶¡»Øµy¤j

1221+.jpg
2023-12-21 21:25

TOP

¦^´_ 3# cypd


    ½Ð§ï¥Î¤½¦¡¬°¡G
B3¡G=LEFTB(P4,16)
B4¡G=MIDB($P$4,LENB(B3),16)
B5¡G=MIDB($P$4,LENB(B3)+LENB(B4),16)
B6¡G=MIDB($P$4,LENB(B3)+LENB(B4)+LENB(B5),16)
B7¡G=MIDB($P$4,LENB(B3)+LENB(B4)+LENB(B5)+LENB(B6),16)
¿Ã¹õÂ^¨úµe­± 2023-12-22 154913.png
2023-12-22 16:07

TOP

¦^´_ 4# goner

«D±`·PÁ  goner  ¦A«×¦^ÂÐ

°w¹ï©Ò´£¨Ñ¥t¤@¸Ñªk...¦ü¥G¹ï©ó­ì¦³ ABC-7890 µP¸¹²£¥Í¯Ê¦r¤@¨Æ
¦p¤U¹ÏÀÉ

1121222.jpg
2023-12-22 23:28

TOP

¦^´_ 5# cypd


    §Ñ¤FÁÙ­n¦A©¹«á1¦ì¤¸¤~¬O­n¨ú±oªº¸ê®Æ¡C
B3¡G=LEFTB(P4,16)
B4¡G=MIDB($P$4,1+LENB(B3),16)
B5¡G=MIDB($P$4,1+LENB(B3)+LENB(B4),16)
B6¡G=MIDB($P$4,1+LENB(B3)+LENB(B4)+LENB(B5),16)
B7¡G=MIDB($P$4,1+LENB(B3)+LENB(B4)+LENB(B5)+LENB(B6),16)

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2023-12-23 12:16 ½s¿è

B3//°}¦C¤½¦¡(¤TÁä¿é¤J)//¤U©Ô
=MIDB(P$3,ROW(A1)*16-15-SUM(N(RIGHT(B$2:B2)=" ")),16)
©Î
=TRIM(MIDB(P$3,SUM(LENB(B$2:B2))+1,16))

¤@¯ë¿é¤J
=MIDB(P$3,ROW(A1)*16-15-SUMPRODUCT(N(RIGHT(B$2:B2)=" ")),16)
©Î
=TRIM(MIDB(P$3,SUMPRODUCT(LENB(B$2:B2))+1,16))

ª`·N:¦r¦ê¤¤¤£¯à¦³ªÅ¥Õ¦r¤¸

TOP

¥»©«³Ì«á¥Ñ cypd ©ó 2023-12-23 21:07 ½s¿è

¦^´_ 6# goner

«D±`·PÁ  goner  ¦A«×¦^ÂÐ
²`·P©êºp¥i¯àªí¹F¤£²M·¡
¥ªÃä B3:B7 Àx¦s®æ¥u¯à®M¥Î P4 ¤§Àx¦s®æ¦ì§}
(¤å¦r¦]»Ý¨D¤£¦P¦³©Ò§ïÅÜ...¨Ò¦p¨®½ø¨Ï¥Î¤£¦P)

1223.jpg
2023-12-23 21:05


1121223.rar (7.75 KB)

TOP

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

·PÁª©¥D ­ã´£³¡ªL ´£¨Ñ¤£¦P¸Ñªk

¿é¥Xµ²ªG¦p¤U
Ãö©ó¿é¤JµP®É B4©Ò²£¥Íªº³¡¤À
¦ü¥Gı±o¦n¹³¤Ö¤F¤@­Ó¦ì¤¸ªº·Pı¡K

1223+.jpg
2023-12-23 21:21

TOP

¦^´_ 9# cypd

¨º¬O15­Ó¦ì¤¸, «á­±¬O¤¤¤å¦r, ­Y¥[¶i¥h´N¶W¹L16¦ì¤¸

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD