- ©«¤l
- 2808
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2864
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-5-8
|
¥»©«³Ì«á¥Ñ ã´£³¡ª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¤¸ |
|