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

¸ê®ÆµLªk¥[Á`

¸ê®ÆµLªk¥[Á`

½Ð°Ý¦U¦ì«e½ú
book1Àɮ׸̪º¸ê®Æ¬O±qºô¯¸¤Udownload¤U¨Óªº
¦ý¬O©_©Çªº¬O ¦³¨Ç¸ê®Æ¬O¼Æ¦r,¦³¨Ç¤£¬O
°£«D­«¥´¤@¹M,¤£µM³o¨Ç¬Ý°_¨Ó¹³¼Æ¦rªº¤å¦rµLªk¥[Á`(À³¸Ó¬Oºô¯¸¸ê®Æ®wªº°ÝÃD)
¦³¬Æ»ò¤èªk¥i¥H¸Ñ¨M©O?
§Ú¦³¸Õ¹L¸ê®Æ­åªR,ÁÙ¬O¤£¦æ


Book1.rar (4.05 KB)

¦^´_ 1# maomin

³o­Ó¸ê®Æ¤Ó¸Þ²§¤F¡AµLªk¥Î
http://support.microsoft.com/kb/181298/zh-tw
ªº¤è¦¡³B²z

µy·L¬ã¨s¤F¤@¤U¡Aµo²{¨C­Ó¦³°ÝÃDªº¸ê®Æ¡A¨äLEN()¬Ò¬O¼Æ¦rªºLEN()+1
¤]´N¬O»¡¦h¤F¤@­Ó²ö¦W¨ä§®¡A§Ú¤£ª¾¹D¬O¤°»òªº¦r¤¸
¦]¦¹B1¤½¦¡
  1. =IFERROR(1*A1,LEFT(A1,LEN(A1)-1)*1)
½Æ»s¥N½X
¤U©Ô¡A§Y¥i¸Ñ¨M
(2003ª©¨S¦³IFERRORªº¸Ü­n§ï¦¨ISERRORªº¼gªk
  1. =IF(ISERROR(1*A1),LEFT(A1,LEN(A1)-1)*1,1*A1)
½Æ»s¥N½X
¤£¹L³o­Ó¦h¥X¨Óªº©_©Ç¦r¤¸¬O¤°»ò¡A¬°¤°»ò¥ÎCLEAN()¤§Ãþªº¨ç¼ÆÁÙ¬O®ø¤£±¼
³o³¡¤À§Ú¥\¤O¤£¨¬¡AÁÙ¦³½Ð°ª¤â¸Ñµª

TOP

B1 ¼W¥[¤@»²§U¦C ¤½¦¡
=IF(ISNUMBER(A1),A1,--SUBSTITUTE(A1,RIGHT(A1),))

c1 ¤½¦¡ =SUM(B:B)
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2013-5-25 13:04 ½s¿è

B1 =-LOOKUP(,-LEFT(A1,ROW($1:$16)))
¤U©Ô

½Æ»s - ¿ï¾Ü©Ê¶K­È ¦^AÄæ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥Ñºô­¶¤U¸üªº¼Æ¦r¡A¦³®É§t¦³ÁôÂær¤¸¡A¤j³¡¥÷¦b¡e¥ª°_¡f²Ä¢°¦r¡F
§Q¥Î=LEFT(A1) ¤Î =RIGHT(A1) ¡A¥H¥ª©Î¥k²Ä¢°¦r¤ñ¸û¡A§Y¥i§PÂ_¬O¥ª©Î¥k¡I
¨Ò¦p¡GA1 = 1089¡AB1¡G= LEFT(A1) ¤½¦¡µ²ªGÅã¥Ü¡eªÅ¥Õ¡f¡AC1¡G=RIGHT(A1) Åã¥Ü¡e9¡f¡Aªí¥ÜÁôÂær¤¸¬°¡e¥ª²Ä¢°¦r¡f¡A
ÁôÂær¤¸­Y¦b¡e¥ª¡f¡AÂà´«¤½¦¡¡G=--MID(A2,2,99)¡@¦b¡e¥k¡f¡A«h¡G=--LEFT(A1,LEN(A1)-1)

Âà´«¤½¦¡Áö¥i¥Î¡A¦ý­Y¤u§@ªí³\¦hÄæ¦ì³£¦³°ÝÃD¡A´N¤£¬O¦n¤èªk¡A
¨Ï¥Î¡e¨ú¥N¡f§Y¥i²M°£¾ã­¶¤u§@ªíªºÁôÂær¤¸¡A¤@¦¸¸Ñ¨M¡A
¢°¡D¿ï¨úB1¡e½Æ»s¡D¶K¤W­È¡f¡AÂùÀ»¥ªÁä¨ÏB1¦¨½s¿èª¬ºA¡A«öShift¤£©ñ¡A¦A«ö¤è¦VÁä¡e¡ö¡÷¡f¡A­Y¬Ý¨ìB1Åܦ¨¶Â´Î¡A§Y¥i«ö¡e½Æ»s¡f¡A
¢±¡D¿ï¨ú¾ã±i¤u§@ªí¡A¥´¶}¡e¨ú¥N¡f¥\¯à¡A¥H¡eCtrl + V¡f±NÁôÂær¤¸¶K¤J¡e´M§ä¡f­È®Ø¡A¦A«ö¡e¥þ³¡¨ú¥N¡f§Y¥i¡I

¬Ý°_¨Ó½ÆÂø¡A¥u­n¦h°µ´X¦¸´N«Ü§Öªº¡I
°Ñ¦Ò§Y¥i¡A¤]³\ª¬ªp¨Ã«D¦p¦¹¡I

TOP

ÁÂÁ¦U¦ì¤j¤jªºÀ°¦£,°ÝÃD±o¤w¸Ñ¨M

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD