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

½Ð°Ý¤@­ÓRight¨ç¼Æ°ÝÃD

½Ð°Ý¤@­ÓRight¨ç¼Æ°ÝÃD

½Ð°Ý§Ú¦³Àx¦s®æ¤º¦³¦r¦ê
¨Ò¦p
123r2r54aaaa
124ww5aaaa
358w74aaaa
12e548aaaa
¦p¦óRight¥Î¨ç¼Æ
¿z¿ï¥ªÃä²Ä1¦ì¨ì¥kÃä­Ë¼Æ²Ä¤­¦ì
123r2r54
124ww5
358w74
12e548
Tony

¦^´_ 1# tonycho33

³]A1¬°²Ä1­Ó¦r¦ê
B1=LEFT(A1,LEN(A1)-4)
1

µû¤À¤H¼Æ

    • gong: ¤£¿ùºc«äª÷¿ú + 2

TOP

register313¤j¤jªº¤èªk¡A²³æ¹ê¥Î¡I

­Y¤@©w­n¥Î [right]³o­Ó¨ç¼Æ¡A
·s¤B¦³¥H¤Uªº¹Á¸Õ¡A
¸U±æ¨£¯º¡I
B1=MID(A1,1,LEN(A1)-LEN(RIGHT(A1,4)))
­Y¦³¿ùº|¡A½Ð¦U¤j¤j´£¥X¤Î«ü±Ð¡I

TOP

=REPLACE(A1,LEN(A1)-3,4,)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD