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

²Â¤p«Ä

=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¾Ç­ÌÀ°¦£

²Â¤p«Ä

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

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

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

JBY

A1 : 01-02-03 12345

B1 :

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

²Â¤p«Ä

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

JBY

ÁÂÁÂ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))