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

[µo°Ý] «ç»òÅý¦W¦r¤¤¶¡¬OO(¤½§i®ÉºûÅ@Áô¨p)

[µo°Ý] «ç»òÅý¦W¦r¤¤¶¡¬OO(¤½§i®ÉºûÅ@Áô¨p)

¦b¸Õºâªí¤¤­Y­nºûÅ@Áô¨p
¦W¦r:³¯ßN®S-----³¯O®S
     ¶À¾å©ú-----¶ÀO©ú
     ªL¤p¤¤-----ªLO¤¤
½Ð°Ý¥i¥H¥Î­þ­Ó¨ç¼Æ¨Ó¸Ñ¨M¶Ü?
·s¤â¾Çexcel

¦^´_ 1# sujiuanjiuan

°²³]­ì¸ê®Æ¦b A1 Àx¦s®æ
B1¤½¦¡=REPLACE(A1,2,1,"O")

TOP

¦^´_ 1# sujiuanjiuan

   
=IF(LEN(A1)=2,REPLACE(A1,2,1,"O"),REPLACE(A1,2,LEN(A1)-2,REPT("O",LEN(A1)-2)))

¦p¹Ï.jpg (6.79 KB)

¦p¹Ï.jpg

¨S¨Æ´N¨Ó³}³}

TOP

¦^´_ 2# jackdream


    ·N«ä¬O"A1"Äæ¦ì²Ä"2"­Ó¦r°_ªº¤U"1"­Ó§ï¬°"O"¡A¹ï¶Ü¡H
·s¤â¾Çexcel

TOP

¦^´_ 3# fr447446


³o­Ó¤½¦¡¡A«Ü¼F®`°Ú¡I¡I¡I¥i¥H¸Ñ¨M½Æ©m°ÝÃD¡I
¦ý«ÜÃø²z¸Ñ¡A¤]«ÜÃø°O°_¨Ó­C¡ã
·s¤â¾Çexcel

TOP

¦^´_  jackdream
    ·N«ä¬O"A1"Äæ¦ì²Ä"2"­Ó¦r°_ªº¤U"1"­Ó§ï¬°"O"¡A¹ï¶Ü¡H
sujiuanjiuan µoªí©ó 2010-11-3 23:08


±NA1Àx¦s®æªº²Ä2­Ó¦r,¥HO¨ú¥N

¦pªG¦Ò¼{½Æ©m,¤]¥i¦Ò¼{¥u¯dÀY§À,¤¤¶¡¥þ³¡¥HO¨ú¥N
=IF(LEN(A1)=2,LEFT(A1,1)&"O",LEFT(A1,1)&REPT("O",LEN(A1)-2)&RIGHT(A1,1))

TOP

«Ü¦n¥Îªº¤è¦¡
THANKS..

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD