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

[µo°Ý] dde¶Ç¦^¤º®e©M¼Æ­È°ÝÃD

[µo°Ý] dde¶Ç¦^¤º®e©M¼Æ­È°ÝÃD

=xxxxxxxxx|'R1TF1'!'+0@1:1'

dde¶Ç¦^¤º®e©M¼Æ­È¡G01-02-03   12345

½Ð°Ý¥i¥Î¨º­Ó¨ç¼Æ¤½¦¡¨Ó§â01-02-03ÁôÂéÎ删±¼¡A»¡©ú¤@ÂI01-02-03¬O©T©w¤º®e¡A¦Ó12345¼Æ­È¬OÅܰʪº¡C

ÁÂÁ¦Ѯv©M¦P¾Ç­ÌÀ°¦£

ÁÂÁÂJBY¦Ñ®vÀ°¦£¡A³o¤½¦¡¨Ï¥Î¤W§ó¥[²z·Q¡C
²Â¤p«Ä µoªí©ó 2012-9-29 10:27


¨ä¥L¤èªk :

=--MID(A1,FIND(" ",A1)+1,255)

=--RIGHT(A1,LEN(A1)-FIND(" ",A1))

=-LOOKUP(1,-RIGHT(A1,ROW($1:$15)))

=--TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",50)),50,50))

TOP

A1 : 01-02-03 12345

B1 :

=REPLACE(A1,1,FIND(" ",A1),)
JBY µoªí©ó 2012-9-28 20:22


ÁÂÁÂJBY¦Ñ®vÀ°¦£¡A³o¤½¦¡¨Ï¥Î¤W§ó¥[²z·Q¡C

TOP

A1 : 01-02-03 12345

B1 :

=REPLACE(A1,1,FIND(" ",A1),)

TOP

¦^´_ 1# ²Â¤p«Ä

=RIGHT(xxxxxxxxx|'R1TF1'!'+0@1:1',5)

¦n¹³¦¨¥\¤F¡C

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD