¤½¦¡1:
X2 = B2 & C2 & D2 & .... & W2
¤½¦¡2:
X2 = CONCATENATE(B2,C2,D2, .... ,..., W2)
¤½¦¡3:
X2 =PHONETIC(B2:W2)
¥H¤W¤TÓ¤½¦¡¹ï©ó³sÄòÀx¦s®æ³£±o¨ì¤@¼Ëµ²ªG,
½Ð°Ý¦b¥Î©ó³sÄò储¦s®æ®É
1. ³£¥i¥H¥Î¤½¦¡3¶Ü? (¦]¬°¼g°_¨Ó«Ü²¼ä)
2. ¤½¦¡1©M2 À³¸Ó§¹¥þ¤@¼Ë¹ï¶Ü?
½Ð°ª¤â«ü±Ð.
¨Ò¦p:- ¤é´Á ¤j¶µ ¤p¶µ ²Ó¸` B+C+D
- 1¤ë 1 ¥ë¹ ¦À\ ¶ºÄ{ ¥ë¹¦À\¶ºÄ{
- 1¤ë 2 ¥ë¹ ¤ÈÀ\ °®ÄÑ ¥ë¹¤ÈÀ\°®ÄÑ
- 1¤ë 3 ¥ë¹ ¦À\ 3¨Ê¯a¦W ¥ë¹¦À\3¨Ê¯a¦W
- 1¤ë 4 ¥ë¹ ¦À\ ¶ºÄ{abc ¥ë¹¦À\¶ºÄ{abc
- 1¤ë 5 ¥ë¹ ¦À\ 3¨Ê¯a¦W ¥ë¹¦À\3¨Ê¯a¦W
- 1¤ë 6 ¥ë¹ ¦À\ ¶ºÄ{ ¥ë¹¦À\¶ºÄ{
- 1¤ë 7 ¥ë¹ ¦À\ ¶ºÄ{ ¥ë¹¦À\¶ºÄ{
- 1¤ë 8 ¥ë¹ ¦À\ ¶ºÄ{Sonny ¥ë¹¦À\¶ºÄ{Sonny
½Æ»s¥N½X |