乖乖 asked in 電腦與網際網路軟體 · 1 decade ago

excel A欄加B欄=C欄(給20點

如;A欄是奇摩

B欄是知識家

C欄是奇摩知識家

問:C欄要用者麼樣的公式或做法呢?

3 Answers

Rating
  • 甯鈞
    Lv 7
    1 decade ago
    Favorite Answer

    =CONCATENATE(奇摩,知識家)

    此為標準答案

    Source(s): excel
  • masa
    Lv 6
    1 decade ago

    如a1=奇摩,

    b1=知識+

    則c1公式=a1&b1

    (=奇摩知識+)

    希望有是版大所要問的

  • 老夥
    Lv 7
    1 decade ago
Still have questions? Get your answers by asking now.