- ©«¤l
- 396
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 425
- ÂI¦W
- 1
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2013-7-2
- ³Ì«áµn¿ý
- 2024-8-23
|
¦^´_ 3# inhogold
¥u¦³¤U¸üªþ¥ó¤~¦³Åv°ÝÃD¡A¤W¶Ç¨S¨î¡A§A¥ý§âÀɮק˦¨À£ÁYÀÉ¡A¦A¤W¶Ç§Y¥i¡C
¥t¥~§A¬O¥un ":" «e±ªº¼ÆȶܡH
¦]¬°¦Ûq®æ¦¡ªºÃö«Y¡A§Ú¨S¿ìªkª½±µÂà´«¤å¦r®æ¦¡¡A
§Ú¬Oª½±µ§â¨º¤@¾ãÄæcopy¨ì°O¨Æ¥»¤W¡A
µM«á¥ý§ä¤@Äæ§â¥L®æ¦¡§ï¬°¤å¦r¡A¦A§â°O¨Æ¥»ªº¤º®e¥þ¿ï«á¶K¤W¡A
³o¼Ë´N¥i¥H¥Î¤½¦¡¨Ó§ì ":" «e±ªºÈ¤F
B1=LEFT(A1,FIND(":",A1)-1)
¦Ü©ó¥¿½T¤S§Ö³tªº¤èªkÁÙ¬O¦³½Ð¨ä¥Lªº°ª¤â¨Ó¸Ñµª¤F ~ |
|