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

¦p¦ó§R±¼©T©wªº¦r¤¸?

¦p¦ó§R±¼©T©wªº¦r¤¸?

§Ú¦³­Ó·Å«×°O¿ý³nÅé¡A
¥L·|¿é¥X¦¨excelÀÉ¡A
¦ý¬O³o­Ó³nÅé·|¦b·Å«×«á¤è¥[ª`c©Îf(¦p¤U)¡A
31.00C
31.13C
0.94C
¦ý¬O³o¼Ë´N¨S¦³¿ìªkª½±µµe¦±½u¡A
½Ð°Ý¤@¤U~
°£¤F¤â°Ê§R¤§¥~¡A
¦³¨S¦³¤°»ò¤èªk¦Û°Ê§R±¼³o­Óc§r?

·s¤â¤W¸ô¡A¦p¦³¹H³W½Ð§iª¾¡A
ÁÂÁÂ

¥»©«³Ì«á¥Ñ p212 ©ó 2015-11-27 08:27 ½s¿è

¦^´_ 1# delaseinekimo
°²³]·Å«×¼Æ¾Ú¦ì©óAÄæ¡AÂà´««á¼Æ¾Ú¦ì©óBÄæ
«hÀx¦s®æB1¿é¤J
=--LEFT(A1,LEN(A1)-1)
©Î
=--SUBSTITUTE(A1,"C","")
¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I
ª`¡G¤½¦¡¤¤¡u--¡vªº¥\¥Î¬°¤å¦rÂà¤Æ¦¨¼Æ¦r

TOP

«e½ú±z~¤Ó±j¤F~~
¨Ï¥Î¤U­±ªº¤½¦¡´N·d©w¤F¡A

ÁÂÁÂ


©Î
=--SUBSTITUTE(A1,"C","")
¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I
ª`¡G¤½¦¡¤¤¡u--¡vªº¥\¥Î¬°¤å¦rÂà¤Æ¦¨¼Æ¦r

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD