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

¦p¦ó¥i¥H²³æ±NÀx¦s®æ»PÀx¦s®æªº¤º®e³sµ²

¦p¦ó¥i¥H²³æ±NÀx¦s®æ»PÀx¦s®æªº¤º®e³sµ²

¥­®É·|¥Î & ±NÀx¦s®æªº¤º®e³sµ²
¦pA1&B1&C1&D1
¦ý¬ùªG·Q³sµ²A1¦ÜA20ªº¤º®e, ·|¦³Â²³æ¤½¦¡¶Ü?
½Ð«ü±Ð

¦^´_ 1# enoch

    ¦pªG³£¬O¤å¦r¥i¨Ï¥ÎPHONETIC¨ç¼Æ
=PHONETIC(A1:A20)
1

µû¤À¤H¼Æ

    • HUNGCHILIN: ¥Îªº¦n ¤ñ¤º©wªºCONCATENATE¨ç¼Æ¦³¥Î¦h¤Fª÷¿ú + 5
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Hsieh

ÁÂÁ§A
¦n¯«©_ªº¤½¦¡, Ú»EXCEL»¡©ú®É³£ÉN´£¨ì¥i¥H¦X¨Ö¤å¦r,
¥i±¤§Úªº¦r¦ê¤¤¥¿¥¿¥]¬A¤F¼Æ¦r¦b¤º

TOP

b1=a1
b2=b1&a2©¹¤U©Ô¦Üb20
b20´N¬O©Ò­nµª®×
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

PHONETIC,¤S¾Ç¤F¤@­Ó,·PÁÂ
chenray

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD