Excel 可以只篩選頭三個數字嗎?

你可以用[查詢], 鍵入 SQL command 即可.

舉例, 假設 Table 名係 MyTable, 欄位係 MyField, 則 SQL 係:

SELECT * FROM MyTable WHERE LEFT(MyField,3)='621'


Hope this help.

2008-04-01 09:17:39 補充：
Yes. philipwong326 是正確的.
我睇錯左係 Access. ^_^"

用 Data Pull-down Menu 的 AutoFilter function 在該欄上

選 Custom，然後填上
is greater than or equal to 621000

AND

is less than or equal to 621999

Assume those data in column A1 through A8

then you can put this formula in cell B1

=left(A1,3)

then you will see the following in Column B

621
724
621
825
934
621
724
621

Then you can use Autofilter (ALT+D+F+F) to find 621 in column B.

done.