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

ÃøÃD!!! ¶Ç¦^Àx¦s®æ¤º®e¡A¥Ñ¥k¦Ü¥ª

­Y¤£¨Ï¥Î¥¨¶°ªº±¡ªp¤U¡A¥i¾î¦V±N¨C­ÓÀx¦s®æªº¤º®e¦ê°_¨Ó¡A¦A¨ú³Ì¥kÃ䪺¦r¤¸¡AÀ³¸Ó´N¬O³Ì°ªª©¦¸¤F¡C
G2Àx¦s®æªº¤º®eÀ³¸Ó¬O"=RIGHT(CONCATENATE(B2,C2,D2,E2,F2),1)"
PS.
1¡BCONCATENATE()³Ì¦h¥i¦³30­Ó¤Þ¼Æ¡A¬G³Ì¦h¥i§P©w¾î¦V30­ÓÀx¦s®æªº¤º®e¡C
2¡BCONCATENATE()¤]¥i§ï¥Î"&"¨Ó´À¥N¡A¨Ò¦p¡G"=RIGHT(B2 & C2 & D2 & E2 & F2,1)"¡]&«e«á¥i¥H¤£»ÝªÅ®æ¡^

¥H¤W¬O¤p§Ìªº©å¨£¡A­Y¦³¨ä¥¦¿ìªk¡A¤]½Ð¤£§[«ü±Ð¡AÁÂÁ¡C
George Ma

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD