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

¦p¦ó§R°£¬Ý¤£¨£ªºªÅ¥Õ

¦p¦ó§R°£¬Ý¤£¨£ªºªÅ¥Õ

¥»©«³Ì«á¥Ñ 97forum ©ó 2011-3-7 16:54 ½s¿è

§Ú±qºô¸ô¤W§ì¨ú¬Y­Óªí¦C¡AÂà¶K¦ÜExcel¤W¡A¥Ñ©ó­ìºô­¶¤W¦³Java©ÎªÌ¬OVBAªº¤Ä¿ïÄ涵¡A©Ò¥H§Ú¤S±N¨äÂà¶K­È¦Ü¥t¤@­Ó·sªº¤u§@ªí¤W¡C
¦]¬°§Ú·Q±N¬Y­ÓÄæ¦ì¤º®e§Q¥Î¤½¦¡±N¨äÂন§Ú·Q­nªºÅã¥Ü¤è¦¡¡A¦ý¬O¦]¬°¼Æ¦rÄæ¦ì¤¤¦³¬Ý¤£¨£ªºªÅ¥Õ(¨Ò¦p¡G alt + 160...µ¥)¡A¥H¦ÜµLªk±N¨ä¼Æ¦rÄæ¦ìÂন§Ú­nªºÅã¥Ü¤è¦¡¡A·Q½Ð¦U¦ì¥ý¶i¬O§_¦³¤èªk¸Ñ¨M¡C
p.s. §Ú¬OOffice 2007 ¦s¦¨97~2003ª©¡A¥t¥~§Ú¤]¤w¸g§Q¥Î¹L¨ú¥N¤è¦¡¥h¨ú¥N alt + 160ªº«DªÅ¥Õ¦r¤¸¡A¦ý¤£¦¨¥\¡C


Book4.rar (3.63 KB)

³o©Û¤£¿ù¡C
­ì¨Ó§Ú¤]¬O¥Î Left ¨ú¥X³Ì«á¤@­Ó¦r¤¸«á¡A¦A°µ¨ú¥Nªº¡C
¥ÎAlt- §ó°ª©Û¡C

TOP

½Ð°ÝALT + 160 ¬O§_¥u°w¹ï®à¤W«¬¹q¸£·f°t¿W¥ß¦¡Áä½L¤~¦³®Ä? µ§¹q¸Õ¹L¬O¤£¦æªº, ¬O§_¥u¯à±Ä¨ú = SUBSTITUE(Àx¦s®æ," ", "")?  µ§¹q¨Ï¥ÎSUBSTITUE ¬Ookayªº.

TOP

§ä¤@­ÓªÅ®æ L1¿é¤J
=left(b2)
¦ACOPY  L1 ¨ì´M§ä¥Ø¼ÐÀ³¸Ó´N¥i¥H¤F.
ANGELA µoªí©ó 2011-3-8 23:33



    ³o­Ó¤èªk¸Õ¹L¥i¦æ¡A·PÁ´£¨Ñ¡I

TOP

­n¥Î¼Ð·ÇÁä½L¿é¤J
NB¥i¯àµLªk¨Ï¥Î
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

§ä¤@­ÓªÅ®æ L1¿é¤J
=left(b2)
¦ACOPY  L1 ¨ì´M§ä¥Ø¼ÐÀ³¸Ó´N¥i¥H¤F.

TOP

¦^´_ 14# 97forum
³o¤èªkªº«e´£¬O­nª¾¹D«eºó¦r¤¸¦³´X­Ó?
·í«e«á³£¦³¤£¥i¨£¦r¤¸®É¤@¼ËµLªkÂন¼Æ­È
®Ú¥»¤§¹DÁÙ¬OÀ³¸Ó±N¨ä¥h°£
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÀɮרS°ÝÃD°Ú
¦pªG©Ò¦³¤èªk³£¤£°_§@¥Î,¨º´N¥Îmid¨ç¼Æ³B²z
¦³¼Æ¦rªºÄæ¥Î
=--MID(D2,2,LEN(D2)-2)
ANGELA µoªí©ó 2011-3-8 16:00



    ÁÂÁ±z¡I³o­Ó¤èªkªGµM¬O¦³®Äªº¡A¯uªº¬OÁÂÁ±zÀ°§Ú¸Ñ¨M§ÚªººÃ´b¡A¥u¬O¸£µ¬¤w¸gÂà¶i¦º­J¦P¸ÌµLªkÂà¥X¨Ó¤F¡I
´«¨¥¤§¡A¥L­ì¨Ó®æ¦¡¥þ³¡¬°¤å¦r®æ¦¡¡AÂ^¨ú¥X©Ò­n¤å¦rÂà¶K´NÅܦ¨¼Æ¦r¤F(¥hÀY§À)¡A¯u¬O¤@»yÅå¿ô¹Ú¤¤¤H¡I
¦A¦¸ÁÂÁ¦U¦ìÀ°¦£¡I

TOP

ÀɮרS°ÝÃD°Ú
¦pªG©Ò¦³¤èªk³£¤£°_§@¥Î,¨º´N¥Îmid¨ç¼Æ³B²z
¦³¼Æ¦rªºÄæ¥Î
=--MID(D2,2,LEN(D2)-2)

TOP

·PÁ±z­Ìªº¸Ñµª¡A¨ä¹êµL½×¬O¥ÎÁä½L¿é¤J alt+160(µL½×¬O¥DÁä½L©ÎªÌ¬O¥kÃä¼Æ¦rÁä½L)¡AÁÙ¬O¥Î½Æ»s¶K¤W¤è¦¡¡A¥Ø«e¦b§Ú¤â¤Wªº³o­ÓÀɮ׳£¬O§ä¤£¨ì¸Ó¦r¤¸¡A©Ò¥H§Ú¤S­«·s©ñ¤W¨Ó¤@¦¸¡A§Ú·Q½Ð¦U¦ì¥ý¶i¸Õ¸Õ¬Ý¬O§Úªº¹q¸£¦³°ÝÃDÁÙ¬O§Ú­þ¸Ì§Ë¿ù¤F¡A¬°¦ó¦U¦ì¥ý¶i¥i¥H§ä¨ì¸Ó¦r¤¸¦Ó§Ú«o³£¤£¥i¥H©O?
§Úªº³nµwÅé¡G
ASUS CM5575  Intel Core i3 2.93G  4GRAM
XP Pro 2002 SP3 (5.1.2600.6055)
Office 2007 SP2 (12.0.6425.1000)


[attach]4944[/attach

Book1.rar (3.88 KB)

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD