Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

? asked in 電腦與網際網路程式設計 · 1 decade ago

EXCEL 字串分隔問題

請問一下EXCEL有這功能嗎?

就是我要把 欄位1 的 #1~4 一次分到 欄位二

有這功能嗎?

欄位1    欄位二

"姓名 #01"   空

"電話 #02"   空

"住址 #03"   空

"姓名 #04"   空

....

就變成了

欄位1   欄位二

"姓名"   "#01"

"電話"   "#02"

"住址"   "#03"

"姓名"   "#04"

....

2 Answers

Rating
  • 1 decade ago
    Favorite Answer

    假設欄位一為(A欄),

    請在欄位二(B欄)的地方

    請在A1旁的B1,輸入如下公式:

    =IF(A1="","",LEFT(A1,2))

    在C1輸入下列公式:

    =IF(A1="","",RIGHT(A1,3))

    然後將此兩個公式,往下複製去就好了!

    2008-10-13 17:51:48 補充:

    另也可以用EXECL工具列上的資料剖析,按[資料],選[資料剖析],就會出現精靈,照動作去做,就可以了!(你要用空白做為分隔碼喔)

    2008-10-13 17:54:49 補充:

    用資料剖析,會將你原先的資料,完全改變,若要恢復原貌是很麻煩做的,所以不是很建議用資料剖析的!

  • ?
    Lv 6
    1 decade ago

    只想到VBA

Still have questions? Get your answers by asking now.