excel問題複製362-1貼入表格後如何變成地號碼0362-0001，謝謝?

💰 財經台個人理財

[匿名]

2016-07-23 1:29 am

回答 (1)

Daniel

2016-07-25 2:52 am

.
假設362-1在A1，則B1:

=TEXT(LEFT(A1,FIND("-",A1)-1),"0000")&TEXT(MID(A1,FIND("-",A1),9),"0000")

👍 1 👎 0