ªð¦^¦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³ò



1121221.rar (6.96 KB)

¦^´_ 12# Andy2483

·PÁÂ¥ý¶i Andy2483 ´£¥Ü°Ñ¦Ò¤è¥Ü  ^^

TOP

ÁÂÁ½׾Â,ÁÂÁ¦U¦ì«e½ú
µøı·PÀY§À¹ï»ôªº¤è¦¡,«á¾Ç¾Ç²ß¤è®×¦p¤U
³]©w«e:


³]©wµ²ªG:
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 9# cypd


¤@­Ó¤¤¤å¦r(©Î¥þ«¬¦r)ºâ2­Ó¦ì¤¸, ¥b«¬¦rºâ1­Ó¦ì¤¸,
8­Ó¤¤¤å¦r´N¬O16­Ó¦ì¤¸, ¤¤¶¡§¨Âø¥b«¬¦r, ´N¤£¥i¯à¨C¦æ§¹¥þ¹ï»ô,
¦Û¦æ¥hºâ~~~

TOP

¦^´_ 9# cypd

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

TOP

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

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

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

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)



1121223.rar (7.75 KB)

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

¦^´_ 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

¦^´_ 4# goner

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

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

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD