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

Excel¤¤¥h±¼¬A¸¹©M¬A¸¹¤º¤º®e

Excel¤¤¥h±¼¬A¸¹©M¬A¸¹¤º¤º®e

Excel¤¤¥h±¼¬A¸¹©M¬A¸¹¤º¤º®e,¦ý¬O¦pªG¨S¦³¬A¸¹«ç»ò«O«ù­ì¸ê®Æ?

Â^¨ú.JPG (34.55 KB)

Â^¨ú.JPG

¤è¦¡¤@=IFERROR(LEFT(A5,FIND("(",A5)-1),A5)


¤è¦¡¤G=LEFT(A5,FIND("(",A5&"(")-1)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD