- ©«¤l
- 93
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 134
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS7
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-3-21
- ³Ì«áµn¿ý
- 2020-11-30
|
ª½±µ¥Î¸ê®ÆåªRÀ³¸Ó¤£¦æ,¥i¥H¥Î¤½¦¡
°²³]¼Æ¾Ú¦bA2
B2=LEFT(A2,LOOKUP(1,0/(MID(A2,ROW(1:20),1)="-"),ROW(1:20))-1)
C2=SUBSTITUTE(SUBSTITUTE(A2,B2,""),"-","") |
|