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

©â¨ú¤£¨ì¥¿½T¦r¤¸ªº¦r¼Æ

©â¨ú¤£¨ì¥¿½T¦r¤¸ªº¦r¼Æ

½Ð°Ý°ÝÃD¥X¦b­þ¸Ì?  ¦n¸Þ²§³á

©â¨ú¤£¨ì¥¿½T¦r¤¸ªº¦r¼Æ.rar (4.57 KB)

¥»©«³Ì«á¥Ñ gong ©ó 2010-7-10 18:04 ½s¿è

=MID(SUBSTITUTE(A8," ",""),1,4)
学习

TOP

¦r­º¦³¬Ý¤£¨£ªºªÅ¥Õ
»Palt+160
¬Û¦P

§â¥L¨ú¥N¬°ªÅ«á´N·|¥¿±`

gong.rar (9.63 KB)

ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 2# wqfzqgk


    ¤£ª¾¬O§_§@·~¨t²Î¤£¦P,,  §Ú®M¥Î¤F¤½¦¡,, ÁÙ¬OµLªk¸Ñ¨M²Ä¤@­Ó¦r¤¸¬Ý¤£¨ìªºªÅ®æ£°, ¥X¨Óµ²ªGÁÙ¬O¤@¼Ë,

TOP

¿ï¨úAÄæ
½s¿è/´M§ä¨ú¥N
¦b´M§äÄæ¦ì
Alt+160
¥þ³¡¨ú¥N
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# gong


ª©¥D,  §Úªº¥\¤O¹ê¦b¤Ó²L¤F,,, ÁÙ¬O¤£ÁA¸Ñ
1.  ¦r­º¦³¬Ý¤£¨£ªºªÅ¥Õ   "»Palt+160¬Û¦P"
¦¹¥y¤£À´ !!!!  ¦³¸Õ¹L  «ö¦í alt ¦A key 160 ¥i¬O¨S¦³°Ê§@!!

2.  §â¥L¨ú¥N¬°ªÅ«á´N·|¥¿±`
   ¬O¥Î ´M§ä ªÅ®æ  ¦A¨ú¥N¶Ü??  ¸Õ¤FÁÙ¬O¤£¦æ,,  §Ú·QÀ³¸Ó¨S¦³³o»ò²³æ

3.  ±zªº¤èªk  »Ý­n¦h«Ü¦hÄæ«á¦A¥Î CONCATENATE ²Õ¦X,,,  ÁÙ·|¦³§ó¦n¤èªk¶Ü!!

TOP

¦^´_ 6# wendy

¸Õ¸Õªþ¥ó
    ©â¨ú¤£¨ì¥¿½T¦r¤¸ªº¦r¼Æ.rar (5.58 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2010-7-10 21:45 ½s¿è
¦^´_  gong


ª©¥D,  §Úªº¥\¤O¹ê¦b¤Ó²L¤F,,, ÁÙ¬O¤£ÁA¸Ñ
1.  ¦r­º¦³¬Ý¤£¨£ªºªÅ¥Õ   "»Palt+160¬Û¦P"
...
wendy µoªí©ó 2010-7-10 21:02


1.¥Î5¼Óª©¥Dªº¨ú¥N¤è¦¡
2.
3.¤£¬O­n§A¥þ³¡®i¶},¬O­n»¡¦pªG®i¶}²Ä¤@¦ì¬O¤@­ÓªÅ¥Õ
³o­ÓªÅ¥Õ»PªÅ¥ÕÁ䤣¦P, code(ªÅ¥ÕÁä)=32,code(ªÅ¥Õ)=63,
¦b½s¿è¨ú¥N®É,Áä½L¤WµLªkª½±µ¿é¥X­n¥Î´¡¤J¦r©Î½Æ»s©Î¿é¤Jalt+160,¨Ó¿é¤J´M§ä¤º®e
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ zz5151353 ©ó 2010-7-10 21:54 ½s¿è

B6

=LEFT(SUBSTITUTE(A6,LEFT(A6),),2)

C6

=MID(SUBSTITUTE(A6,LEFT(A6),),3,3)
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

«éµM¤j®©,,,,  ®³­Ó·}ÀYÂñ§Ú¦Û¤v¤@¤U§a!!    ÁÂÁÂ!!!  ¨ü±Ð¤F!!   
¶X¦¹¾÷·|,,,
·PÁ½Ѧ쪩¥D¦p¦¹¼ö¤ß,  ¶}ÅP¤F¦¹½×¾Â,,¬Û«H¦U¦ìªº²z©À,,¤@©w¯à§ó¥[µo´­¥ú¤j, ³z¹L³o­ÓºÞ¹D, ¼W¶i¦n¦h, ¤×¨ä¬O¤É¯Å¥i¥H down ¸ê®Æ«á, §ó¬O¤S¸ó¤F¤@¨B,,,  ¥[ªo¥[ªo,,

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD