Excel Formula Query

2011-08-22 6:12 am

2010121600010223004640一串數字中, 怎樣寫公式抽取第9,8,7位置的數字,即223出來?

回答 (3)

2011-08-22 7:35 pm

✔ 最佳答案

=mid(a1,7,3)

7 = no, of start position
3 = no. of character to retrieve

2011-08-22 11:36:25 補充：
in your case,

=mid(a1, 14,3)

👍 0 👎 0

2011-08-22 3:48 pm

=LEFT(RIGHT(A1,9),3)

2011-08-22 07:52:38 補充：
VBA:

Variable = Left(Right(Source, 9), 3)

👍 0 👎 0

2011-08-22 8:30 am

用笨笨的VBA Mid(Cell(row,column), 9, 3) ?_?

👍 0 👎 0